Menu
How do I view the schemas, that belong to a database in SQL Developer? I am trying to get a view similar to Toad. In that you have the database name at the parent level, all the schemas below it which are then expandable to view all the objects that belong to that particular schema.
855
To open, right-click on the connection name and select Schema Browser. It also helps to browse through other schemas based on the permissions granted in the database.
SQL> select distinct owner from dba_objects; >> Will give you the list of schemas available. select username from dba_users; this output will list all users including sysdba,system and others.
To show the schema, we can use the DESC command. This gives the description about the table structure.
Expand the "Other Users" node.
81
Two steps :
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
