3 Replies - 1295 Views - Last Post: 16 July 2014 - 08:12 AM

#1 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 497
  • View blog
  • Posts: 3,314
  • Joined: 12-January 10

how can I just write a sql query liek in mssql

Posted 16 July 2014 - 06:02 AM

I am using oracle for my 2nd time ever. In mssql server you can just right click a db and select new query and write a query into it and return what you are looking for.... how can you do the same in oracle?
Is This A Good Question/Topic? 0
  • +

Replies To: how can I just write a sql query liek in mssql

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9570
  • View blog
  • Posts: 36,240
  • Joined: 12-June 08

Re: how can I just write a sql query liek in mssql

Posted 16 July 2014 - 07:12 AM

It's been sometime since I had to root around in peoplesoft and that yard of oracle.. but the 'two day dev' guide was handy.

Oracle® Database 2 Day Developer's Guide
2- Connecting to Oracle Database and Exploring It
Was This Post Helpful? 1
  • +
  • -

#3 baavgai  Icon User is offline

  • Dreaming Coder
  • member icon

Reputation: 5929
  • View blog
  • Posts: 12,851
  • Joined: 16-October 07

Re: how can I just write a sql query liek in mssql

Posted 16 July 2014 - 07:23 AM

Um, no. A database server has no GUI, MS SQL, Oracle, or otherwise. It is a server and responds to requests with result sets.

I'm guessing you're asking about functionality similar to that of Microsoft's SQL Server Management Studio?

Oracle's default tool is essentially a console interface, sqlplus. Curiously, MS SQL has something similar, from the sybase days, called osql: but it looks like they're phasing it out.

For true Oracle GUI joy, the only two contenders are Oracle SQL Developer from Oracle proper and Toad.

Start with the first, as it should be a free download. Good luck.
Was This Post Helpful? 0
  • +
  • -

#4 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 497
  • View blog
  • Posts: 3,314
  • Joined: 12-January 10

Re: how can I just write a sql query liek in mssql

Posted 16 July 2014 - 08:12 AM

thanks-- after much looking it came down to oracle likes dumb names for things.... i needed tools>sql worksheet


lame
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1