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

Answer / rahul name

We can use user_tables view of data dictionary.
create a cursor based on query
select * from user_tables and then use use this cursor
in for loop

Answer / highness

I got a lot of definitions for this but i thing this is right

A compiled plsql procedure
stands for a stored procedure...

check out this

Answer / mahesh gulati

select * from sysobjects where type = 'u'

Why do we need databases?

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

What is sql dialect?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

What are sql queries used for?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

What is rtm stands for?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

How do you write an inner join query?

0 Answers  

---

How many types of normalization are there?

0 Answers  

---

What is pl/sql table? Why it is used?

0 Answers  

---