I have setup an oracle database in my Ubuntu machine. Now I have took the following steps to create tables
1) login to my ubuntu account
sqlplus "sys as sysdba"
//Connected to an idle instance
4) sql prompt
Connected to: Oracle Database 12c Enterprise Edition Release 188.8.131.52.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
5) in sql prompt..
sql> exec dbms_xdb_config.sethttpport(8080);
Then I have login to oracle apex in a workspace which I created earlier and created a table named
but when I again login to to sqlplus like
sqlplus "sys as sysdba" and run the following query
select * from person
It says , no table created.
I am a newbie in database , so please tell me how do I access the tables I have created in apex , from sqlplus console ? It used to be so simple in 10g.