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'

In a table only one column how to update rows

5 Answers   Microsoft,

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What is sql not null constraint?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

What is a sql schema used for?

0 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

What is the difference between sum and count in sql?

0 Answers  

---

What is primary and foreign key?

0 Answers  

---

What is mdf ldf and ndf?

0 Answers  

---

What is Histogram?

0 Answers   NIIT,

---

What is rownum and rowid?

0 Answers  

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---