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!

Search results for query: *

  • Users: michal
  • Content: Threads
  • Order by date
  1. 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 "simplified" version namely DECLARE TYPE CourseList IS...
  2. 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