Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. michal

    How do you set an SQL statement condition using an array?

    Hi Jeremy, You can use a sub-query similar to this Select employee,salary from EMPLOYEETABLE where salary NOT IN ( SELECT salary FROM lvw WHERE salary<>g_Packet_type ) HTH, Michal
  2. michal

    Manipulating Local Collections (using TABLE and CAST)

    I am trying to work with the examples from http://oradoc.photo.net/ora81/DOC/server.815/a67842/04_colls.htm (search for Manipulating Local Collections ) Since I do not have permission to create a new type I tried to use a &quot;simplified&quot; version namely DECLARE TYPE CourseList IS...
  3. michal

    ORDER BY clause inside a subquery in a cursor

    Thanks very much. I will try this work-around tomorrow. Thank you so much for your time and patience!!
  4. michal

    ORDER BY clause inside a subquery in a cursor

    Thanks again karluk. I suspect you might be right!! BTW: Does anyone know where I can find a list of the bugfixes in oracle 8.1.6? Thanks, Michal
  5. michal

    ORDER BY clause inside a subquery in a cursor

    Thanks karluk for your answer. However, I have tested again and SELECT ROWNUM,z.* FROM (SELECT 'hello','world' FROM DUAL ORDER BY 1) z does work in SQl-Plus (I am using oracle version 8.1.5.0.0 if that makes a difference) I am still seeking an answer to my original question: why isn't this...
  6. michal

    ORDER BY clause inside a subquery in a cursor

    Hi, I hope this subject isn't too confusing! I am trying to excute the following DECLARE CURSOR p_cursor1 IS SELECT rownum,z.* FROM (SELECT 'hello','world' FROM DUAL ORDER BY 1) z; BEGIN OPEN p_cursor1; CLOSE p_cursor1; END; This generates the error PLS-00103: Encountered the symbol...

Part and Inventory Search

Back
Top