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 need of merge statement?

1032

---

Is sql a dbms?

996

---

what is subquery? : Sql dba

1125

---

how to shut down the server with 'mysqladmin'? : Sql dba

1004

---

What is a constraint?

1013

---

What is difference between ms sql and mysql?

956

---

What is trigger and types?

1021

---

What is difference between sql and mysql?

1117

---

What is a natural join?

1058

---

Explain what is table in a database?

1055

---

Can we rollback delete command?

980

---

What is parameter substitution in sql?

1021

---

How to select 10 records from a table?

1153

---

Explain isolation levels. : Transact sql

1063

---

What is sql prepared statement?

976

---