Answer / Reshu Agarwal

The time it takes to learn PL/SQL depends on various factors such as prior programming experience, learning pace, and the depth of understanding desired. However, a basic understanding can typically be achieved in several weeks or months with consistent practice and study.

What is sql in oracle?

1 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

When is the explicit cursor used ?

1 Answers  

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

what is a database lock ? : Sql dba

1 Answers  

---

What is a merge query?

1 Answers  

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

What is rownum and rowid?

1 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What is crud stand for?

1 Answers  

---