What is sql character function?
How many tables can you join in sql?
find the third highest salary?
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
what is julian date in oracle
What is a primary key called that is made up of more than one field?
What is the use of partition by in sql?
Define the select into statement.
Can we commit inside a trigger?
What is sql and also describe types of sql statements?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
Is sqlexception checked or unchecked?
what are the advantages and disadvantages of views in a database? : Sql dba