Rupesh Mishra
asked on
ORA-00923: FROM keyword not found where expected
Hello experts,
Below is working in SQL Server version.
SELECT 'Kevin' FirstName ,'P' LastName , 32 Age
Myproblem is when i am running this in oracle it is giving me
Error(s), warning(s):
ORA-00923: FROM keyword not found where expected
Any help is appreciated.
Below is working in SQL Server version.
SELECT 'Kevin' FirstName ,'P' LastName , 32 Age
Myproblem is when i am running this in oracle it is giving me
Error(s), warning(s):
ORA-00923: FROM keyword not found where expected
Any help is appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just as an added explanation. Oracle requires that all select statements must have a from clause. The table dual is a table of one column, dummy,and one value, 'X', that make it easy to select literal values. You could also have used SELECT 'Kevin' FirstName ,'P' LastName , 32 Age from any existing table where rownum = 1;