![]() Here is the PLSQL query that does the job without you having to copy, but the only problem here is the formatting but that can be matched by rewriting to suit your need. The PLSQL Query without DESC to describe tables Once the result is printed with a table prefixed with desc you can execute all of them in bulk to get results. ![]() If you want to get all the tables across all the schema you can use all_tables instead of user_tables select 'desc '||table_name If you prefer to do that you can use the following SQL snippet to get all your tables in your schema select 'desc '||table_name to get the list tables and adding DESC before it and executing it later. I had a similar requirement and I came to know that DESC does not work within PLSQL. ![]() It is not so efficient to use DESC for all the tables one after another. ![]() At times, while we want to get a list of tables and their columns along with their data types from Oracle. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |