Search results for query: *

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 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 =...

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)...

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...

Hi all: I creted a table in oracle and added 1 record to it through SQLPlus Insert Into mytable (fld1, fld2) values (str1, str2). From within MsAccess I created a link to myTable, and no records were return, then I added 2 record from access in the linked table and works ok. Still just this 2...

Hi guys: I didn't found any bitwise operators in oracle, so I suppouse I should build a function for this (let me know if I'm wrong). Then how can I convert a number to it's binary representation in oracle? byte=1: 0000 0001 byte=4: 0000 0100 result: 0000 0101 Thank's.. Aishel

Hi: This is my access query Select (EmFirst || EmLast) theName, RTrim(theName) theNameTrimmed From EmTable; The point is that in msAccess I do can reference a field (theName) defined inside the same query. Can I do it in oracle? Thanks a lot, in advance...

Hi all, I'm new in oracle, this is my issue. I created in oracle9 a new table. Then in an access database I tried to link that oracle table trought ODBC and a datasource created to my oracle db but not all the tables for the user appears listed in the &quot;link tables listbox&quot;. Is there...