When do we use triggers?
What are analytical functions in sql?
Write a query to get 2nd maximum salary in an employee table ?
69 Answers Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,
what are different types of collation sensitivity? : Sql dba
What is varray in pl sql?
What is rtm in testing?
How to return an array from java to pl/sql?
What is db journal file?
What is sqlcontext?
How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 Answers Mind Tree, Polaris, Sonata,
Why stored procedure is better than query?
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?
how to present a past time in hours, minutes and seconds? : Sql dba