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;
/

Can I join the same table twice?

1095

---

How many types of tables are there?

996

---

What type of join is sql join?

1022

---

What is linq to sql?

1178

---

Is microsoft sql free?

1141

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3619

---

How do you declare a constant?

1016

---

Which is faster joins or subqueries?

1036

---

Is sql port 1433 encrypted?

1086

---

How many tables can you join in sql?

1006

---

Why left join is used in sql?

1019

---

how to convert character strings to numeric values? : Sql dba

1163

---

How do I tune a sql query?

1040

---

What is normalization sql?

1114

---

Is pl sql useful?

1037

---