Which data type is a composite type?
Can you select everything, but 1 or 2 fields, without writer's cramp?
write the Sql query for creating database backup?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Why do we use procedures?
What does count (*) mean in sql?
What is the difference between delete, truncate and drop command?
what is SCALAR Queries?
Differentiate between syntax and runtime errors.
How did you export data from database to excel file.
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
how will be date change into string