senior walk

SQL: Listing courses with SYSTEM DSK

  • Publication date 2010-10-21
  • Categories: Notes
  • Categories:

select course_id||’,’||batch_uid||’,’||course_name||’,’||’1109′ from course_main where data_src_pk1=2 AND course_id like ‘1109%’; To export this list to a file, I’ve used: 

SQL> set pagesize 0;
SQL> set linesize 300;
SQL> spool migrate_systemcourses.txt;
SQL> select course_id||','||batch_uid||','||course_name||','||'1109' from course_main where data_src_pk1=2 AND course_id like '1109%';
SQL> SPOOL OFF
]]>