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

what does the t-sql command ident_current does? : Transact sql

546


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

552


Can we call stored procedure in function?

553


What are the sql versions?

522


what is 'trigger' in sql? : Sql dba

559






how to run 'mysql' commands from a batch file? : Sql dba

610


What is the difference between distinct and unique in sql?

475


In a distributed database system, can we execute two queries simultaneously?

571


How do I truncate a word?

528


what is the command line end user interface - mysql? : Sql dba

505


What does <> sql mean?

542


What is indexes?

545


what is the difference between union and union all? : Sql dba

548


How to use distinct and count in sql query? Explain

613


What is informix sql?

540