Explain spool.

0 Answers  

---

How would you convert date into julian date format?

0 Answers  

---

Give the order of sql select?

0 Answers  

---

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?

4 Answers   KPIT,

---

What is the usage of the distinct keyword?

0 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What is the file extension for sql database?

0 Answers  

---

What are pl/sql cursor exceptions?

0 Answers  

---

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

What is a clob in sql?

0 Answers  

---