Qh3y9_jXw/U7ihZHDxzKI/AAAAAAAAAMw/3RMYdUygE3Q/s1600/img2.jpg' alt='Sql Ed Wrote File Afiedt.Buf' title='Sql Ed Wrote File Afiedt.Buf' />Ya David, I agree Pipelined function is also a program unit, but this is way to get the pipelined data in form of table, similar to casting or selection of data from an object. I referred it as a concept that data selection can be made only from Database table, which might be object or relational. MSTS - Addon - Dieselswest CNW SD40-2 Set. Your original statement clearly statesIn oracle, selection of data is possible only from Tables, not from program units. Your statement, as you made it, is, unfortunately, incorrect. Is it possible to somehow do this WITH T1 AS SELECT 1 AS SEQ, NOTHING 1 AS SOMETYPE FROM DUAL UNION ALL SELECT 2 AS SEQ, NOTHING 2 AS SOMETYPE FROM DUAL. Steve, Im looking for a Javaprocedure executing host calls on a Unix environment from the Oracleserver. I know the standard way of doing it by means of ProC for. I want to use this SQL query to get only the records between 8 and 10 select from SELECT a. FROM ACTIVESESSIONSLOG a ORDER BY USERID ASC WHERE rn. Hello, Here is my problem. I need to get the last business day of the month. If i use the LASTDAY function it will give me the last day but. Notice that you load the ref cursor in the first procedure, pass it back to the PLSQL block or another procedure and fetch from it as you would a declared cursor. How to with PLSQL code import load data into an Oracle table from a delimited text file from Win95 directory sqlplus login as User system want to access vdatabase to get the database name out by EXECUTE IMMEDIATE select name into vDBname from vdatabase I.