OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » syntax doubt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

syntax doubt [message #242202]

Fri, 01 June 2007 01:07

rajalakshmi
Messages: 5
Registered: May 2007

Junior Member

I have data in oracle database.I need to report the tables in asp.net application.
In my asp page when i run a query like "select name as "emp name" from empoyee" following error is occuring.
ORA00923 from keyword not found where expected.
so i gave like this
"select name as emp name from empoyee".This also causing compilation error.
How i have to enclose the alias name?
i tried for different combinations.not found correct answer.
using .net framework 2.0 and orace 10g express edition.
plz reply

Report message to a moderator

Re: syntax doubt [message #242204 is a reply to message #242202]

Fri, 01 June 2007 01:16

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select ename as "emp name" from emp;
emp name
----------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
MILLER

14 rows selected.

Works for me.
This is not a SQL problem. Have a look at how you assign your variable in your code.

Regards
Michel

Report message to a moderator

Re: syntax doubt [message #242210 is a reply to message #242202]

Fri, 01 June 2007 01:36

Frank
Messages: 7901
Registered: March 2000

Senior Member

If you use double quotes (") surrounding your statement, you have to somehow escape the double quotes you use for the alias. This is an ASP thing, not an Oracle thing.

Report message to a moderator

Previous Topic:	bulk collect & delete
Next Topic:	PLS-00364 while creating a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 18:03:44 CST 2024