Explain the use of rows option in imp command.
What is a cursor and what are the steps need to be taken?
State all possible different index configurations a table can possibly have?
How to find no of saturdays in a month using single sql ?
How do I spool in oracle?
what is data independence exactly? give an example
Is rowid unique in oracle?
What are the uses of Rollback Segment ?
difference between truncate and delete ,drop?
What would you use to improve performance on an insert statement that places millions of rows into that table?
State and explain the different types of data models?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
How to add a new column to an existing table with a default value?