[
removing a bunch of probably uninterested people from CC
]
On mán, 2006-12-04 at 22:12 +0530, Ashish Ahlawat wrote:
> Hi Team
>
> Thanks
>
> FOR your prompt responseBut USING CASE issue still NOT
> resolvedOracle prompts same error.
this is a postgresql mailing list, but
I believe t
> Thanks FOR your prompt responseBut USING CASE issue still NOT resolved
> Oracle prompts same error.
I see, was answers to you get from the oracle mailing lists regarding this
problem? ;o)
Regards,
Richard Broersma Jr.
---(end of broadcast)
Hi Team
Thanks FOR your prompt responseBut USING CASE issue still NOT resolved
Oracle prompts same error.
Team its a simple query but really instresting one...
Following data has been updated IN TABLE DVDs
INSERT INTO DVDs (Name, NumDisks, RatingID, StatID)
VALUES('Mash', 2, 'R', 's2'
Ashish Ahlawat wrote:
Hi Team
I am unable to fetch data using following simple query it prompts
following error
*ORA: 00907: Missing right parenthesis*
Query :-
SELECT
Name AS Title, StatID AS Status, RatingID AS Rating,
IF(NumDisks>1, 'Check for extra disks!', 'Only 1 disk.') AS Verif
> *ORA: 00907: Missing right parenthesis*
> Query :-
> SELECT Name AS Title, StatID AS Status, RatingID AS Rating,
> IF(NumDisks>1, 'Check for extra disks!', 'Only 1 disk.') AS Verify
What kind of error is ORA? Is this an oracle error?
In postgresql I do not believe that the "IF" predicate exist
Hi Team
I am unable to fetch data using following simple query it prompts following
error
*ORA: 00907: Missing right parenthesis*
Query :-
SELECT Name AS Title, StatID AS Status, RatingID AS Rating,
IF(NumDisks>1, 'Check for extra disks!', 'Only 1 disk.') AS Verify
FROM DVDs
*Table Struct
