Search code examples
oracledbaasoracle-cloud-infrastructure

How to see the tables created on oracle cloud

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.

Solution

  • 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.

    enter image description here

    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.