Print Thread
PL/SQL Devloper
#57161 10/17/17 05:02 PM
Joined: Feb 2015
Posts: 1
St. Petersburg, Florida
V
Member
OP Offline
Member
V
Joined: Feb 2015
Posts: 1
St. Petersburg, Florida
Hi, have been learning Oracle SLQ for a couple of years, self-teaching. Question: is there a feature in the client application (Allround Automations) in which I can get a a list of tables with fields in a schema? Or is there code to do so?


Am a newbie! Have PL/SQL Developer, ver 9.0, by Allround Automations.
Re: PL/SQL Devloper
victoria #57162 10/17/17 05:40 PM
Joined: Mar 2000
Posts: 204
Akron, OH, USA
Member
Offline
Member
Joined: Mar 2000
Posts: 204
Akron, OH, USA
Try

Code
select * from user_tab_cols


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.038s Queries: 15 (0.015s) Memory: 2.4958 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 13:02:27 UTC
Valid HTML 5 and Valid CSS