sql*plus newbie question

[182]

Hey guys, I was wondering is there any way i can use sql*plus on a single computer rather than with a server just for testing queries or is there any other software i could use for testing queries?

Thanks in advance.

[jkoopmann]

SQL*Plus can be installed on a client machine alone but it is just a command line interface to the database on your server. Therefore you must always be connected to the database server to test your queries. After all, how could you "test" if the tool didn't know the layout of tables.

Now that being said I do know that Computer Associates has, as part of their SQL Station product, the ability to do some testing and modeling of queries without running against the database. I have only seen this demoed and am sure it has to connect to the database to pull back object deffinitions.

[182]

Hi Thanks for your reply, when i said tesing i mean is there anyway i could have the program set up so i could input simple tables to test my queries without having to use a database server?

Thanks.

[rmiao]

How can you create table without connect to oracle server?

[jkoopmann]

you can not.