Re: Lower Case Table Name ( Help me get rid of it )

Use double quotes. For example

select * from "Test_1"

TurkBear wrote in message <34be62a6.77548619_at_news.primenet.com>...
>Using a conversion utility I am evaluating, I managed to create an
>Oracle ( 7.3.2.1.1, Netware ) table with lower case ( i.e. Test_1 ) -
>Now, of course, I need to get rid of it since SqlPlus will not work
>with it ( Table not Found when I try a Select * from Test_1 and
>'Object does not exist' when I try a desc test_1 ) - How do I get rid
>of this odd little table?
>
>PS I have learned to specify the Table name in Upper case only when
>using this conversion tool, so I won't have this problem again.
>
>Thanks for any hints :
>Post here or Email to john.greco_at_dot.state.mn.us
Received on Fri Jan 16 1998 - 00:00:00 CST