Answer Posted / chandrakant rathod

We can get all tables for particular instance using below block .

SET SERVEROUTPUT ON;
begin
for rec in (select object_name from user_objects where object_type='TABLE')
loop
dbms_output.put_line('TABLE'||rec.object_name);
end loop;
end;
/

What is the difference between rollback and rollback to statements?

1060

---

What is optimistic concurrency control? : Transact sql

987

---

What is sql entity?

1108

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4025

---

Name some usages of database trigger?

1021

---

What is a record in pl/sql?

1151

---

Can we use ddl commands in pl sql?

1164

---

what is meant by urlencode and urldocode? : Sql dba

1178

---

What is consistency?

1131

---

What are the sql commands?

1185

---

How are sql commands classified?

1092

---

Why do we use function in pl sql?

1065

---

What is difference between table and view?

1063

---

what is table? : Sql dba

1068

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1015

---