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 many sectors are in a partition?

560


Is a table valued function object?

577


Can a composite key be null?

526


How can you tell the difference between an index and a view?

489


What does <> sql mean?

538






Can you join a table to itself?

540


How do you drop a trigger?

540


How to run sql statements through the web interface?

511


what are rollup and cube in t-sql? : Transact sql

657


What is sequence in sql?

506


How do you determine the current isolation level? : Transact sql

575


Why is nosql good?

593


how to write date and time literals? : Sql dba

528


What is the difference between microsoft access and sql server?

531


what is a unique key ? : Sql dba

543