Click here to Skip to main content
15,793,452 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
can any one help me how can i find how much table is in schema1 and how to copy all table of schema1 to another schema2 in pl/sql using sp ??

select * from sys.tables

for the count of tables:

select count(*) from sys.tables
Share this answer
its perfect bt its half so plz help how to use this in sp and use it
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900