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 --------------------------------------------------------------------- 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