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 many joins in sql?
Can we interchange parameters in procedure while calling
Why truncate is faster than delete?
What are the various restrictions imposed on view in terms of dml?
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
why we use nocopy?
how will you find out the last three records in a table with n no of records and delete them
What is materialised View?
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
why we go for package? what are the advantages of using instead of seperate procuderes or functions
What is string join?
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?