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

    SELECT in FROM clause not working

    You could also run a script from sql plus set pagesize 0 set linesize 120 Spool runme.sql SELECT distinct 'Select * from '||s.tablename ||';' FROM sourcedef s, attriblist a WHERE a.attribid=1 and a.sourceid = s.sourcedefid / Spool Off Spool Myresult.txt @runme.sql spool off ed Myresult.txt...
  2. vinperla

    using UPDATE in dbms_sql

    Steps a.Should Be declare Cursor b. Parse Check your sqlstatement c. Execute d. Close cursor_handle := dbms_sql.open_cursor dbms_sql.parse (cursor_handle ," delete from mytable" ,dbms_sql.v7); results := dbms_sql.execute...

Part and Inventory Search

Back
Top