DESC <table> statement not working

Hi

I am trying to get definition of table with basic command -
DESC MYTALBE
System throws following error -
System.Data.OracleClient.OracleException: ORA-00900: invalid SQL statement
I am able to connect to Oracle database as other queries running fine.
Thanks for the for the help, in advance
0
konda
8/14/2003 1:44:16 PM
asp.net.oracle 2269 articles. 0 followers. Follow

2 Replies
565 Views

Similar Articles

[PageSpeed] 53

Hi,

DESC (describe) isnt a valid sqlstatement, it's a sqlplus command (hence the error). If you want to describe a table, you could probably SELECT * FROM SOMETABLE WHERE 1=0, then check the metadata on the resultset, although I havent tried it myself.
Cheers,
Greg
0
greg
8/18/2003 2:13:17 AM
Hi Greg,

If that is the reason why I am getting error, its really stupid and silly error.
I will try this.
Thanks for tracking me to right way

0
konda
8/18/2003 9:56:58 AM
Reply:

Similar Artilces:

Put a table (like <table><td></td></table>) in a Datagrid
Hello First of all, I just want to advise that I'll have many questions about datagrid for the next few days. I have to display a datagrid that seems very complicated for me (newbie in vb.net)  So I display an image in my datagrid where the name of my image is in my datagrid's linked table. This is working fine. Now I would like to have a link like "Enlarge Image" below the image displayed. I guess that I need a table to do this to. I would like also to put a header text but I guess this is another question that I'll have to post later Thank you in advance for ...

"<table></table>" and "<frameset><frame></frame></frameset>" in perl/tk
Dear my friends... Anybody would be so kind telling me what is similar in perl/tk to arrange the location of a form written in perl/tk? I want a nice look for my perl/tk application. Somewhat like this below: 1. Name : <place to type-in> 2. Address : <place to type-in> 3. Telephone : <place to type-in> I have made the main menu of my application with "Menubutton". And I want if the user click on the menu that what the user see is only the aimed application displayed on the determined area (under the main menu) but the menu has no change in po...

superreview cancelled: [Bug 4510] table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) : [Attachment 135353] patch
Boris Zbarsky <bzbarsky@mit.edu> has cancelled fantasai@escape.com's request for superreview: Bug 4510: table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) http://bugzilla.mozilla.org/show_bug.cgi?id=4510 Attachment 135353: patch http://bugzilla.mozilla.org/attachment.cgi?id=135353&action=edit ...

superreview granted: [Bug 4510] table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) : [Attachment 141121] patch
Boris Zbarsky <bzbarsky@mit.edu> has granted fantasai@escape.com's request for superreview: Bug 4510: table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) http://bugzilla.mozilla.org/show_bug.cgi?id=4510 Attachment 141121: patch http://bugzilla.mozilla.org/attachment.cgi?id=141121&action=edit ------- Additional Comments from Boris Zbarsky <bzbarsky@mit.edu> >Index: mozilla/layout/html/table/src/nsTableCellFrame.cpp >-NS_METHOD >+NS_METHOD > nsTableCellFrame::Paint(nsIPresContext...

superreview requested: [Bug 4510] table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) : [Attachment 141851] patch
fantasai@escape.com has asked David Baron <dbaron@dbaron.org> for superreview: Bug 4510: table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) http://bugzilla.mozilla.org/show_bug.cgi?id=4510 Attachment 141851: patch http://bugzilla.mozilla.org/attachment.cgi?id=141851&action=edit ...

superreview requested: [Bug 4510] table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) : [Attachment 141121] patch
fantasai@escape.com has asked Boris Zbarsky <bzbarsky@mit.edu> for superreview: Bug 4510: table, row, column, *-group backgrounds not working correctly (<col>, <colgroup>, table, style, background) http://bugzilla.mozilla.org/show_bug.cgi?id=4510 Attachment 141121: patch http://bugzilla.mozilla.org/attachment.cgi?id=141121&action=edit ------- Additional Comments from fantasai@escape.com forgot to mention: the only difference between the nsTablePainter files previously attached and the ones I just put up is the comments and a couple lines I swapped in PaintCel...

Lists in .net
Like a good AKA accessible app building developer, my application's navbar is controlled with CSS and using <ul> and <li> I just have the code in the HTML display and it works fine when everything should be visible, however, I need to restrict some users from viewing certain navbar links based on their security levels.  How do I hide the list items that need to be hidden? TIA hello! give them ids and runat="server" attribute. then in code behind set the Visible property to false. orzeh code less, think more! Okay, I tried putting the link as a link bu...

superreview requested: [Bug 344505] role="anything" on <table> should remove roleless <td>'s, <th's> from hierarchy : [Attachment 229522] Any role on a table means the table structure descendants are
Aaron Leventhal <aaronleventhal@moonset.net> has asked for superreview: Bug 344505: role="anything" on <table> should remove roleless <td>'s, <th's> from hierarchy https://bugzilla.mozilla.org/show_bug.cgi?id=344505 Attachment 229522: Any role on a table means the table structure descendants are no longer structurally relevant, unless they have their own role. They're being used to layout the container. https://bugzilla.mozilla.org/attachment.cgi?id=229522&action=edit ...

superreview cancelled: [Bug 344505] role="anything" on <table> should remove roleless <td>'s, <th's> from hierarchy : [Attachment 229522] Any role on a table means the table structure descendants are
Aaron Leventhal <aaronleventhal@moonset.net> has cancelled Aaron Leventhal <aaronleventhal@moonset.net>'s request for superreview: Bug 344505: role="anything" on <table> should remove roleless <td>'s, <th's> from hierarchy https://bugzilla.mozilla.org/show_bug.cgi?id=344505 Attachment 229522: Any role on a table means the table structure descendants are no longer structurally relevant, unless they have their own role. They're being used to layout the container. https://bugzilla.mozilla.org/attachment.cgi?id=229522&action=edi...

how do you prevent a bunch of <tr><td></td></tr> from adding space to a table?
Hello, how do you prevent a bunch of <tr><td></td></tr> from adding space to a table? Thanks   Hello alex: > how do you prevent a bunch of <tr><td></td></tr> from adding space to a table? You need to get rid of blanks inside the td tags. In instance:    <td>      <img src="image.gif" />   </td> should be:    <td><img src="image.gif" /></td> For more control over code formatting, keep in mind that blanks *inside* a t...

<Page-UP><Page-Down>< HOME><END> Keys still dont work 8^(
Name: Dave Henderson Email: nr1dxatarrldotnet Product: Firefox Summary: <Page-UP><Page-Down>< HOME><END> Keys still dont work 8^( Comments: The subject says it all .... Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one you must BCC (not CC) the sender for them to see it. ...

What does this means: Duplicate index <TABLE> UNIQUE (Id) for table <TABLE>
Hi, After I reloaded our database file the following message occur in the Sybase (ASA8) Engine when I run our application: Duplicate index <TABLE> UNIQUE (Id) for table <TABLE> The db-file is upgraded from SQL Anywhere 5.03 -> ASA8.01 using the command: dbunload -c <connect string> -an <db-file> -ek <key> Can anyone please tell me what this means and what do do about it? The message occurs only if I update the db-file. The application works fine with the new engine and the old db-file. Thanks in advance K...

Is <p><!-- pagebreak --></p> working with SM
If a receive an HTML mail from per exemple phpmailer.php ans this mail is in an HTML format.... Is this paragraph <p><!-- pagebreak --></p> acting as a skip to a new page, when i print the mail received by my SM email client ? Ray_Net wrote: > If a receive an HTML mail from per exemple phpmailer.php ans this mail > is in an HTML format.... > Is this paragraph <p><!-- pagebreak --></p> acting as a skip to a new > page, when i print the mail received by my SM email client ? Maybe the author was hoping it would, but there is no reason ...

<<<help>>> how does "IStateManager" works?
I have created a simple custom control with the following classes...and i'm trying to understand once i add the item into IStateManager how can i retrieve in from .aspx.cs ? here are the simple classes: 1    public class Appointment : StateManagedItem2        {3            #region Properties4    5            public DateTime? Start6            {7     ...

Web resources about - DESC <table> statement not working - asp.net.oracle

Resources last updated: 11/28/2015 5:00:21 AM