Recent content by amortillaro

Oh! Here is my sql statement: Select EmKey, AttDate, ROW_NUMBER() OVER (PARTITION BY EmKey ORDER BY AttDate) LinkDiscretShadow From Att_view Where (AttDate >= To_Date('01/01/2004','MM/DD/YYYY')) Thanks again... Aishel

Hi all, I have here the version 806 of oracle db. I need to know from which version of the database the analytics functions are implemented. I know that for versions 8xx the analytics functions are not implemented for the pl/sql ( http://www.quest-pipelines.com/newsletter-v3/0402_D.htm under...

Hi sem: I found the final answer in http://www.quest-pipelines.com/newsletter-v3/0402_D.htm and there can be read: ANALYTIC FUNCTIONS AND PL/SQL In 8i, the analytic functions cannot be used in PL/SQL (in 9i, this is overcome as the SQL and PL/SQL parsers are merged). To work around this...

Actually against 8i, but is this not included in the 8i version, if not I think this is the wrong forum, but how can I work around this with the 8i version? And yes, was in pl/sql window. Thanks.. Aishel

I'm trying to use the following sql statement and looks like the line with the row_number() is not right at all. What am I missing? Error: FROM keyword not found where expected. Select EmKey, AttDate1, ROW_NUMBER() OVER (PARTITION BY EmKey ORDER BY AttDate1) SeqTest, field4, field5...

Steph why the portion "(ORDER BY 1)" I didn't know about it. What is the difference with this one? Select rownum enumerator, decode(sign(rownum-11), -1, 'T', 'F') SLA, fld1, fld2, fld3, fld4 From Att_tbl_Test Aishel

Or even more short... UPDATE EachPercent SET (BlankPercentAlloc) = ( Select PercentAlloc From AllPercents WHERE (EachPercent.Lx_SeqNum = AllPercents.SeqNum) ) WHERE (EachPercent.Lx_Date >= To_Date('01/04/2004', 'MM/DD/YYYY')) And (EachPercent.Lx_Date <= To_Date('01/18/2004'...

Then the where part in the subquery does not play any role?. If I'm ok then the result query will be UPDATE EachPercent SET (BlankPercentAlloc) = ( Select PercentAlloc From AllPercents WHERE (EachPercent.Lx_SeqNum = AllPercents.SeqNum) ) WHERE (EachPercent.Lx_Date >=...

Hi guys: I have this query: UPDATE EachPercent SET (BlankPercentAlloc) = ( Select PercentAlloc From AllPercents WHERE (EachPercent.Lx_Date >= To_Date('01/04/2004', 'MM/DD/YYYY')) And (EachPercent.Lx_Date <= To_Date('01/18/2004', 'MM/DD/YYYY')) AND (EachPercent.Lx_SeqNum =...

14 digits, where 3 of them are decimals ###########.###

Hi all: I'm creatinga package, with a procedure. Inside that procedura I'm declaring the following cursor and a variable of it's rowType: CURSOR crEmOneDay(pcrEmKey varchar2, paramDate date) IS Select EmKey, AttDate1, ClockIn, ClockOut From Att_Employees Where ((EmKey = pcrEmKey)...

Go http://otn.oracle.com/documentation/migration.html You have to download the Oracle Migration Workbench, then download the pluggin for Access, install and run. Let us know... Aishel

As far as I have found, Access can insert in a master-detail view, it seems that it manage the workaround when the record already exist in the master part. Oracle does not take care of that, so if the relation is not one to one, an error is raised. Does somebody have more ideas about this...

Hi guys: another fresh day, and a question.. I have this two tables: CREATE TABLE Att_Test (FLD1 NUMBER(7,0) NOT NULL, FLD2 VARCHAR2(10) NULL, FLD3 VARCHAR2(10) NULL, FLD4 VARCHAR2(10) NULL, CHECK (FLD1 IS NOT NULL), PRIMARY KEY (FLD1)) ; CREATE TABLE Att_TestChild (FLD1 NUMBER(7,0) NOT...

Thank all you for help me with this. I greatly appreciate it. Now everything is working great, but a lot slowly than I predicted, but that's other thread theme. Sincerely.. Aishel