Answer / bhavya

Select
Listagg(rownum*3, ', ') within group (order by rownum desc)
From dual
Connect by level<=100/3;

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

What does the argument [or replace] do?

0 Answers  

---

How to add a column ‘salary’ to a table employee_details?

0 Answers  

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 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 operators deal with null?

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

What are database links used for?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

What is rowid in sql?

0 Answers  

---

How can I change database name in sql?

0 Answers  

---