Interested to Buy Any Domain ? << Click Here >> for more details...
How to perform a loop through all tables in pl/sql?
- 4 Answers
- 17276 Views
- Evosys, MBT, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is rank () in sql?
What is pls_integer in pl sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How many sql statements are used? Define them.
Can we use commit inside a trigger?
What does the argument [or replace] do?
What is case function?
What is transaction control language (tcl)?
What is cross join example?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is an exception in PL/SQL? What are the two types of exceptions?
What is a natural join sql?
what is sub-query? : Transact sql
How to load data with sql*loader?
Is sql dba a good career? : SQL DBA
