hope that i don't muddy the waters here, but there's a solution for all of your data sources that doesn't require knowledge of any commands.
the corereader app loads and displays the information that you want when you connect to a data source, in this case to a database. it's free as a download from http://www.corereader.com/ . i've tested it against both mysql and oracle enterprise server. others have run it against everything from mainframes to spreadsheets. you can create a library of connections in it and switch between data sources with point and click. the first time that you run it, it comes up in novice mode. change it to the "proficient" level in the config screen. hope that i've not wasted your time by telling you something that you don't need. > Figured it out. just use the "use name_of_db" and you can switch to another > DB. > > thanks. > > > -----Original Message----- > From: Norris, Joseph > Sent: Wednesday, September 25, 2002 9:02 AM > To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R > Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List > (E-mail)' > Subject: RE: Win32::ODBC Question (Oracle) > > > Ian's help worked great. I have one question. How do I specify the DB? > I mean in the query analyzer I can select a db from the pulldown box - is > there a way to specify the db in the statements below? > > Thanks. > > > -----Original Message----- > From: Ian Robertson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 8:50 AM > To: 'Norris, Joseph'; 'Peter van der Goes'; 'Thomas R Wyant_III'; > [EMAIL PROTECTED]; 'Mysql_List (E-mail)' > Subject: RE: Win32::ODBC Question (Oracle) > > > > Hi, > > Use the following: > > SELECT * FROM sysobjects WHERE type='U' > > This will show you all of the user tables > > And then > > select * from syscolumns where ID = (select ID from sysobjects where > name = 'your_tablename' and type = 'U' > > This should get you started! > > HTH > > Ian. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Norris, Joseph > Sent: 25 September 2002 16:47 > To: 'Peter van der Goes'; Thomas R Wyant_III; > [EMAIL PROTECTED]; Mysql_List (E-mail) > Subject: RE: Win32::ODBC Question (Oracle) > > This email leads to a question I have about SQL. I have been accustomed > to > Mysql with all of its nifty little extensions - like describe. Now I > have a > project with MSSQL (not because I wanted it - politics). Does any one > now > how to describe a table structure with standard SQL. Even more important > - > in Mysql there is the show tables; command which allows you to see the > structure of the whole DB. Is there a way to do this in standard SQL? > > Thanks. > > > -----Original Message----- > From: Peter van der Goes [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 8:39 AM > To: Thomas R Wyant_III; [EMAIL PROTECTED] > Subject: Re: Win32::ODBC Question (Oracle) > > > DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC > drivers don't know anything about "DESCRIBE", because it's not a SQL > command. > (Warning - based on recollections of two years ago when I actually > *worked* > for a living) > > ----- Original Message ----- > From: "Thomas R Wyant_III" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, September 25, 2002 8:45 AM > Subject: Re: Win32::ODBC Question (Oracle) > > > > > > [EMAIL PROTECTED] wrote: > > > > > I'm trying to get Information about a spezific table in an Oracle > > > with the command > > > > > 'describe table_name; ' > > > > > This command works within SQL-PLus and other Tools but I get the > > > error message: "Ora-00900: invalid SQL statement" when I use it > > > within a perl-script using a Win32::ODBC connection. > > > > > Does someone know a solution , maybe to use a DBD, DBI module or > > > a different statement to get information about the table definition? > > > > You don't say what information you want about the table. If you want > to > > know what columns are in the table, and what data types are in the > columns, > > you perform a select against the table, and then pull the data out of > the > > selection results. If you don't want any data at this point, the usual > > dodge is to specify a "where" clause that is never satisfied. In fact, > the > > usual dodge is > > > > select * from your_table where 1 = 0 > > > > I don't know of any better way under DBI, but you need to know less > about > > your data types if you use DBI, because it supports placeholders. So > > instead of generating the entire text of a query, and worrying about > > whether values need to be quoted, and if so how to escape any embedded > > quotes, you just put a question mark in the query, and provide the > value > > when the query is executed. > > > > Tom Wyant > > > > > > > > This communication is for use by the intended recipient and contains > > information that may be privileged, confidential or copyrighted under > > applicable law. If you are not the intended recipient, you are hereby > > formally notified that any use, copying or distribution of this > e-mail, > > in whole or in part, is strictly prohibited. Please notify the sender > > by return e-mail and delete this e-mail from your system. Unless > > explicitly and conspicuously designated as "E-Contract Intended", > > this e-mail does not constitute a contract offer, a contract > amendment, > > or an acceptance of a contract offer. This e-mail does not constitute > > a consent to the use of sender's contact information for direct > marketing > > purposes or for transfers of data to third parties. > > > > Francais Deutsch Italiano Espanol Portuges Japanese Chinese > Korean > > > > http://www.DuPont.com/corp/email_disclaimer.html > > > > > > _______________________________________________ > > Perl-Win32-Users mailing list > > [EMAIL PROTECTED] > > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > > > > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
