Re: table naming problem
From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Thu, 29 Apr 1999 22:23:53 +0100
Message-ID: <7gaigt$60d$1_at_news7.svr.pol.co.uk>
Date: Thu, 29 Apr 1999 22:23:53 +0100
Message-ID: <7gaigt$60d$1_at_news7.svr.pol.co.uk>
Try and avoid doing it if you possibly can. This is genuine advice, not a facetious comment. Using tables surrounded by quotes should in theory work, but your code will almost certainly be more error-prone as a result.
Simon Hedges
Gloucester
UK
>Gennady wrote in message <3728bc0e$0$2800_at_fountain.mindlink.net>...
>Hello:
>
>Using double quote I CAN create in SQL Plus 8.0 table with mixed case table
>name
>like:
>CREATE TABLE "My_Table" .....
>but when I try to open it in Personal Oracle 8 Navigator I get an error
>message
>ORA-00942:table or view does not exist. Actually it is exists -
>I can DESCRIBE it!
>Do you have any hints to fix this problem?
>
>Gennady
>
>
>
Received on Thu Apr 29 1999 - 23:23:53 CEST