while loading data into database how can u skip header and
footer records in sql*loader
Answer / gretta
The WHEN clause with POSITION can be used to skip header and footer records.
Is This Answer Correct ? | 3 Yes | 0 No |
How to check if a column is nullable before setting to nullable?
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
How do I know if I have sql express or standard?
What is the difference between numeric and autonumber?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is innodb? : Sql dba
What is a temporal table?
Explain what is table in a database?
How to connect a sql*plus session to an oracle server?
Does db2 use sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba