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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by michal

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

Part and Inventory Search

Back
Top