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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
generating sqlplus script from oracle
In order to do this, first set up several statements SET ECHO OFF SET FEEDBACK OFF SET PAGESIZE 0 SPOOL xxxx.sql put sql statements here such as select 'DROP TABLE '||object_name ||';' from user_objects where object_type = 'TABLE' SPOOL OFF SET ECHO ON This is found in the Student...- jdwins
- Post #3
- Forum: Oracle: All versions
-
SQL Loader
We are trying to load comma delimited data in which the character variables are also surrounded by double quote marks into a database using Rel 8.0.5.0.0 of SQL Loader for WIN 95 into the Oracle 8 data base (NT). None of the records loads. The reason given is that the criteria in two when...- jdwins
- Thread
- Replies: 5
- Forum: Oracle: All versions
