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

Bert Scalzo wrote:
>
> 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

sql> rename "Test_1" to TEST_1 Received on Mon Jan 19 1998 - 00:00:00 CST