What is exception? What are the types of exceptions?
how to create a test table in your mysql server? : Sql dba
What is clustered and nonclustered index in sql?
What is trigger in pl sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
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 }
What is dml with example?
how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
What are different joins used in sql?
How do I view a table in sql?
What are secondary keys?
Can we call stored procedure in function?
Can a composite key be null?