What is a mutating table and a constraining table?
Is primary key is clustered index?
Does truncate need commit?
What is output spooling in sql*plus?
How to call the function and Procedure in trigger?
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
How can we store rows in PL/SQL using array?
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
What is rowid in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can we use delete in merge statement?
what are local and global variables and their differences? : Sql dba
How do you remove duplicate records from a table?