Tuesday, January 1, 2008

Oracle 11g Web SQL client

Oracle 11g does not provide the iSQLPlus interface or the GUI SQL*Plus client (sqlplusw). Instead, it provides SQL Developer and APEX (Application Express).

To get a web interface for typing in SQL and getting the results, you can use the Oracle Enterprise Manager (OEM) web interface, accessible at: https://localhost:1158/em (assuming you've got Oracle installed on your computer).

To log into the OEM web interface, you need to have the SELECT ANY DICTIONARY privilege (or you can use the SYSTEM account :-P ). When you're logged in, click on the Data Movement 'tab' and click the SQL Worksheet link (under the related links section). You'll now have the iSQLPlus-like interface for executing SQL queries.

EDIT: If you're using Quest SQL Navigator, you will need version 5.5.4 or later to work with Oracle 11g; this version also supports Microsoft Windows Vista.

4 comments:

junaid said...

HI THERE,
I UNDERSTAND THAT WE HAVE TO GO TO https://localhost:8080/em BUT IT DOESNT ALLOW ME TO ACCESS THE URL. I AM USING WINDOWS XP AND I HAVE TRIED THE URL WITH IE AS WELL AS FIREFOX

AWAITING UR REPLY... PLEASE DROP ME AN EMAIL WHEN THE QUERY IS ANSWERED

THANKS

Adam said...

http://localhost:1158/em

not

http://localhost:8080/em

vineet kumar said...

it is not allowing me to login...user name and password is incorrect...but by 'system' user is only connecting

David Ballesteros said...

Nice.. I didnt find where to execute SQL commands.. Thanks