Home » Applications » Oracle Fusion Apps & E-Business Suite » DECODE
DECODE [message #95922] Fri, 25 June 2004 01:22 Go to next message
Bhavesh
Messages: 7
Registered: July 2001
Junior Member
Explain me clearly DECODE function

Report message to a moderator

Re: DECODE [message #96042 is a reply to message #95922] Sat, 31 July 2004 05:04 Go to previous messageGo to next message
Amitava Chakrabarty
Messages: 2
Registered: July 2004
Junior Member
hi bhavesh,
1.the function decode can be used only in SQL query, cannot be used independently.
2.the function looks like this::
decode(variable,arg1,arg2)
IF the value of the variable is not arg1 then take as arg2.
this was the simpliest example of decode function.

Report message to a moderator

Re: DECODE [message #96046 is a reply to message #96042] Tue, 03 August 2004 01:29 Go to previous messageGo to next message
Bhavesh
Messages: 7
Registered: July 2001
Junior Member
Can we give wildcards in the params of DECODE.

Report message to a moderator

Validation vs Format Trigger [message #96051 is a reply to message #96042] Wed, 04 August 2004 22:12 Go to previous message
Bhavesh
Messages: 7
Registered: July 2001
Junior Member
What's the diff. between format trigger and validation trigger, while applying for a column in a table at runtime?

Report message to a moderator

Previous Topic: Data Transfer Utility from one instance to another.
Next Topic: 11.5.9 Win2k Installation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 12:37:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.