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 Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
