Re: Oracle SQL Client
I like SQL Developer from Oracle - a little slow since it is a Java client and it is free. -- Shyam - Original Message - From: Jill E Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 2:09 PM Subject: Re: Oracle SQL Client ** Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
I have been using TOAD for a number of years now. One of the features is to be able to run a script with TOAD, SQLPlus, or QSR. This way you can use the ability to popup a list of fields for a table or view and check your code before running it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, July 31, 2008 8:29 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe - Original Message From: Jill E [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com http://sqldeveloper.oracle.com/ Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
And you can spool results to a file? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client ** I have been using TOAD for a number of years now. One of the features is to be able to run a script with TOAD, SQLPlus, or QSR. This way you can use the ability to popup a list of fields for a table or view and check your code before running it. Fred -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, July 31, 2008 8:29 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe - Original Message From: Jill E [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 No virus found in this outgoing message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.5.8/1582 - Release Date: 7/30/2008 6:37 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
Yes And since TOAD will allow you to run a script with SQLPLus you get the best of both worlds, context sensitive editing and the full power of SQLPlus (When you say to run the script with SQLPlus it actually starts SQLPlus and passes the script to it). From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, August 01, 2008 10:07 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client And you can spool results to a file? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client ** I have been using TOAD for a number of years now. One of the features is to be able to run a script with TOAD, SQLPlus, or QSR. This way you can use the ability to popup a list of fields for a table or view and check your code before running it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, July 31, 2008 8:29 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe - Original Message From: Jill E [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com http://sqldeveloper.oracle.com/ Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
Cool.. What I did recently was wrote a MS-DOS batch file that created a .sql file, which basically created the necessary .par files to export a production dump of the ARSystem database, to a test database minus all the production application data. I used the command line ability of calling the SQLPlus client to run that sql file to create the necessary .par files and then again the command line ability to exp and imp the data from production to test. The par files were created by spooling results to a .par file.. I still need to work on a couple of things to make that bat file work perfectly, but for the most part I was able to replicate the production ITSP database to a test environment by completely skipping the incident, change, problem and asset data.. I wasn't sure if you could use Toad from the command line to do things like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client ** Yes And since TOAD will allow you to run a script with SQLPLus you get the best of both worlds, context sensitive editing and the full power of SQLPlus (When you say to run the script with SQLPlus it actually starts SQLPlus and passes the script to it). -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, August 01, 2008 10:07 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client And you can spool results to a file? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client ** I have been using TOAD for a number of years now. One of the features is to be able to run a script with TOAD, SQLPlus, or QSR. This way you can use the ability to popup a list of fields for a table or view and check your code before running it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, July 31, 2008 8:29 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe - Original Message From: Jill E [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 -- Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ No virus found in this outgoing message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.5.10/1585 - Release Date: 8/1/2008 6:39 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
SQL Developer - IT'S FREE The Universal Database Frontend (Works with all databases and most platforms). SQL Developer is a is a database administration and query tool that provides a single consistent interface for various databases. Visually navigate through your database structure, create and execute SQL queries and scripts the easy way. Or reverse engineer complete data models with the integrated diagram editor. SQL Developer is available at http://sqldeveloper.solyp.com On Aug 1, 12:13 pm, Joe D'Souza [EMAIL PROTECTED] wrote: Cool.. What I did recently was wrote a MS-DOS batch file that created a .sql file, which basically created the necessary .par files to export a production dump of the ARSystem database, to a test database minus all the production application data. I used the command line ability of calling the SQLPlus client to run that sql file to create the necessary .par files and then again the command line ability to exp and imp the data from production to test. The par files were created by spooling results to a .par file.. I still need to work on a couple of things to make that bat file work perfectly, but for the most part I was able to replicate the production ITSP database to a test environment by completely skipping the incident, change, problem and asset data.. I wasn't sure if you could use Toad from the command line to do things like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 11:15 AM To: [EMAIL PROTECTED] Subject: Re: Oracle SQL Client ** Yes And since TOAD will allow you to run a script with SQLPLus you get the best of both worlds, context sensitive editing and the full power of SQLPlus (When you say to run the script with SQLPlus it actually starts SQLPlus and passes the script to it). -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, August 01, 2008 10:07 AM To: [EMAIL PROTECTED] Subject: Re: Oracle SQL Client And you can spool results to a file? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 10:26 AM To: [EMAIL PROTECTED] Subject: Re: Oracle SQL Client ** I have been using TOAD for a number of years now. One of the features is to be able to run a script with TOAD, SQLPlus, or QSR. This way you can use the ability to popup a list of fields for a table or view and check your code before running it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, July 31, 2008 8:29 PM To: [EMAIL PROTECTED] Subject: Re: Oracle SQL Client Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe - Original Message From: Jill E [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client Greetings Christie, SQL Developer is my graphical tool of choice -http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 -- Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are html___ No virus found in this outgoing message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.5.10/1585 - Release Date: 8/1/2008 6:39 AM ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers
Oracle SQL Client
Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 _ Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] System Office tel: 503-415-5149 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Ivy.gif
AW: Oracle SQL Client
Hi, Maybe tora is right tool for you. Have a look at: http://tora.sourceforge.net/ Best regards /martin Martin Peterken Support System Specialist CRMBilling Development Lycos Europe GmbH Carl Bertelsmann Str. 21 33311 Gütersloh email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] phone: ++49 5241 8071287 fax: ++49 5241 80671287 AIM:MartinPeterken http://www.lycos-europe.com http://www.lycos-europe.com Sitz der Gesellschaft: Gütersloh Amtsgericht Gütersloh, HRB 2157 Geschäftsführer: Christoph Mohn Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von Pargeter, Christie :CO IS Gesendet: Donnerstag, 31. Juli 2008 17:25 An: arslist@ARSLIST.ORG Betreff: Oracle SQL Client Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
Toad is the most common one I'm familiar with...but it's not freeyou can likely check out on source forge for oracle clients and get something that'll work well for you. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, July 31, 2008 9:25 AM To: arslist@ARSLIST.ORG Subject: Oracle SQL Client ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 _ Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Ivy.gif
Re: Oracle SQL Client
TOAD (http://www.toadsoft.com) Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, July 31, 2008 10:25 AM To: arslist@ARSLIST.ORG Subject: Oracle SQL Client Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 -- *Christie Pargeter * * Legacy Health System IS - Programming SR Technical Analyst * [EMAIL PROTECTED] * **System Office* tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle SQL Client
Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe - Original Message From: Jill E [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client ** Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS [EMAIL PROTECTED] wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 Christie Pargeter Legacy Health System IS - Programming SR Technical [EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are