Home » SQL & PL/SQL » SQL & PL/SQL » problem while using select statememt
problem while using select statememt [message #269392] Fri, 21 September 2007 23:38 Go to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Hi All,
I am using a table and oe of its column name is NAME. One of the entry in the column is
Michel's Birthday
. Now i have to use this in where clause .
What should be the query for it?
Thanks and Regards
Sunil Gaurav
Re: problem while using select statememt [message #269393 is a reply to message #269392] Fri, 21 September 2007 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Rhetorical question.... How did you create column name of "NAME"?
select keyword from V_$RESERVED_WORDS where keyword like '%NAME%';

KEYWORD
------------------------------
EVALNAME
GLOBAL_NAME
QB_NAME
NAME
SESSIONTZNAME
NAMED
RENAME
XMLNAMESPACES
USE_WEAK_NAME_RESL

9 rows selected.

>I am using a table and oe of its column name is NAME
please post SQL that actually created table where "column name is NAME"; which is Oracle RESERVED_WORD.
Please post CUT & PASTE of
SQL> DESC <table_name>
which shows column name of "NAME"
Re: problem while using select statememt [message #269395 is a reply to message #269392] Sat, 22 September 2007 00:36 Go to previous message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
SQL Reference (part of Oracle documentation,found eg. online on http://tahiti.oracle.com)
Chapter 2 Basic Elements of Oracle SQL
Literals
Text Literals
Previous Topic: Help with query to break down the effective dates..
Next Topic: need to combine two tables
Goto Forum:
  


Current Time: Wed Nov 13 05:17:06 CST 2024