while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

---

How to get list of all tables from a database?

0 Answers  

---

How do I start pl sql?

0 Answers  

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is delimiter sql?

0 Answers  

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  

---

What is clustered index sql?

0 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

What is data control language (dcl)?

0 Answers  

---