How to perform a loop through all tables in pl/sql?

Answer Posted / mahesh gulati

select * from sysobjects where type = 'u'

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does stored procedure reduce network traffic?

531


Is there any restriction on the use of union in embedded sql?

652


How do sql triggers work?

536


Can a commit statement be executed as part of a trigger?

592


How can I see all tables in sql?

529






What is a string data type in sql?

505


What is use of term?

605


How to know the last executed procedure?

579


How many sql statements are used?

553


Which join is default?

507


Are views faster than queries?

525


Is subquery faster than join?

558


Which sql most popular?

537


What are the types of operators available in sql?

540


How do you write a subquery?

507