Menu
I am new to DBaaS, I created a new oracle cloud account and instantiated a DB.
I am connecting to the DB using SQL developer and created a new table by logging in as sys user.
How do I see the newly created table on oracle cloud using web console?
I can see the data that I have added into the newly created table using SQL Developer, but is there any way or does oracle provides any web-console to see the data using a browser?
Thanks in advance.
467
The easiest way to find all tables in SQL is to query the INFORMATION_SCHEMA views. You do this by specifying the information schema, then the “tables” view. Here's an example. SELECT table_name, table_schema, table_type FROM information_schema.
Tables and columns can be fetched from DBA_OBJECTS , DBA_TABLES and ALL_TABLES . You can specify the names of all the columns or use ' * ' to display all the tables and columns with entire data in oracle database. Using ALL_TAB_COLUMNS in oracle database you can list all tables and columns in a oracle database.
This is possible using OEM Cloud Control. To view data, navigate to database homepage/summary. From the top menu, navigate to
Schema -> Database Objects -> Tables.
Fill in the desired schema and click "Go". This will populate a list of the tables within the schema. Click on the table name to view the table.
Once at the View Table page, select "View Data" from the Actions menu and click "Go". This will return the top 25 rows from the selected table. If there are more than 2000 rows, you will be given the option to select specific columns and add a where clause.
69
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
