Oracle Sql Helf..!

[chinni005]

I'm using NVL function to mask the null values but it is throwing some error..! the query goes...

select (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000') + to_yminterval('18-00'))) BETWEEN (TRUNC(SYSDATE) + 30) AND (TRUNC(SYSDATE + 31))) from person;

can any1 fix this issue pls..!

[CheGuevara]

what is the error

[mettastar]

error emosthundi??

[chinni005]

[quote name='mettastar' timestamp='1363098243' post='1303408722']
error emosthundi??
[/quote]

ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
Error at Line: 14 Column: 88


idhe metta* mama

[chinni005]

[quote name='CheGuevara' timestamp='1363098194' post='1303408719']
what is the error
[/quote]
payina esa chudu che..!

[mettastar]

select Between enduku undhi baa?

[CheGuevara]

[url="http://i.trkjmp.com/click?v=VVM6MzM3NzY6OTczOnNlbGVjdDpmNjU4YjQ2ZWY5ODQxZjFlNGExYzE3NWZkMjU4NzBjZDp6LTEwNjMtMTUyMjQ6d3d3LmFuZGhyYWZyaWVuZHMuY29tOjMzNzg4OmM0MTNkY2U1MzJmZjdhOTA1ZGE3OGM4ZGZhYzg5OGM5"]select[/url] (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000') + to_yminterval('18-00'))) BETWEEN (TRUNC(SYSDATE) + 30) AND (TRUNC(SYSDATE + 31))) from person;

last lo oka paranthesisi theesey...okati ekkuva pettav

[mettastar]

Between where clause lo vaadali

[karna11]

paranthasis ekkuvunnattu vundhii check cheyyi

[Terminator II]

[quote name='RockStarr' timestamp='1363098302' post='1303408725']
ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
Error at Line: 14 Column: 88


idhe metta* mama
[/quote]

right paranthesis miss ayithundanta.. baga chudu vuncle sql.

[mettastar]

nee req idemo anukuntunna

SELECT (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000')
+ to_yminterval('18-00') ))) FROM person
WHERE (((NVL(TO_date(BIRTH_DATE,'DD-MON-YYYY'),'19-JAN-1000')
+ to_yminterval('18-00') )))
BETWEEN (TRUNC(SYSDATE) + 30) AND (TRUNC(SYSDATE + 31))

[littlestar]

nee guddi G..kanipisthane undi kada

[Gachibowli_Diwakar]

try shutdown abort; command at the end of your sql .. everything will resolve

[mettastar]

[quote name='Little Star' timestamp='1363098953' post='1303408784']
nee guddi G..kanipisthane undi kada
[/quote]
kiskoo bolraree

[chinni005]

[quote name='mettastar' timestamp='1363098406' post='1303408734']
select Between enduku undhi baa?
[/quote]
oh idhi resolve ayindhi oka () ekkuva petta