Home » RDBMS Server » Enterprise Manager » Runing a sql query on EM (Oracle 10.2.0.1.0 CentOS 5)
Runing a sql query on EM [message #542814] Fri, 10 February 2012 04:22 Go to next message
Vackar
Messages: 81
Registered: October 2007
Member
Hi,

I have a really simple question.
I'm using oracle enterprise manager I'd like to run a query.
i.e.
select * from user_tables


Which tab/link take me to a page where I can do this.
I've done it in the past, but cannot remember where I accessed it from.

Thanks in advance,
Vackar
Re: Runing a sql query on EM [message #542821 is a reply to message #542814] Fri, 10 February 2012 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59974
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you do it in SQL*Plus?

Regards
Michel
Re: Runing a sql query on EM [message #542823 is a reply to message #542821] Fri, 10 February 2012 05:01 Go to previous messageGo to next message
Vackar
Messages: 81
Registered: October 2007
Member
It's for when I'm working remotely, and don't have vpn access to connect direclty to the Oracle server.

I'm sure there must be a way beacuase I have done this before.
I think there was a worksheet link, but I can't see it under any of the tabs, and google isn't yeilding anything useful.

Vackar
Re: Runing a sql query on EM [message #542834 is a reply to message #542823] Fri, 10 February 2012 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59974
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I'm sure there must be a way beacuase I have done this before.


In this version?

Regards
Michel
Re: Runing a sql query on EM [message #542836 is a reply to message #542834] Fri, 10 February 2012 06:19 Go to previous message
Vackar
Messages: 81
Registered: October 2007
Member
yes it was definately in this version.

I think it was call worksheet or iworksheet or someting along those lines.
Previous Topic: Oracle Port number
Next Topic: disable dbconsole to start on server reboot
Goto Forum:
  


Current Time: Thu Dec 18 02:45:32 CST 2014

Total time taken to generate the page: 0.09901 seconds