Home » SQL & PL/SQL » SQL & PL/SQL » sql fns help
sql fns help [message #224722] Thu, 15 March 2007 04:27 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member

Which of the following functions are available in SQL? (Choose four)
A. INSTR.
B. NVL2.
C. TRUNCATE.
D. DECODE.
E. TRIM.
F. NVL.
G. NULLIF.

pls help wht is the answer for these
Re: sql fns help [message #224728 is a reply to message #224722] Thu, 15 March 2007 04:42 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Go ahead, open a SQL*Plus window and find out.

If you can't/won't you can always check the SQL Reference Wink

MHE

Re: sql fns help [message #224733 is a reply to message #224722] Thu, 15 March 2007 04:55 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Depends on the version.
TRUNCATE is a command, not a function.
NVL2,NULLIF are available from 9i onwards
TRIM is from 8i onwards.

Rest are available from my childhood Cool I think Razz

Edit: Maarten, I didn't see your reply... Anyway I don't want to rollback. Razz

By
Vamsi

[Updated on: Thu, 15 March 2007 04:58]

Report message to a moderator

Previous Topic: Some very strange problem
Next Topic: unique(field1,field2)where field2 is not null
Goto Forum:
  


Current Time: Sat Dec 03 07:47:24 CST 2016

Total time taken to generate the page: 0.04238 seconds