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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.