Exforsys
+ Reply to Thread
Results 1 to 2 of 2

Conditions or Calculation

This is a discussion on Conditions or Calculation within the Oracle Database forums, part of the Database category; I'm trying to change the name of something already programmed into the system. Lets say in Coditions PAC = "I" ...

  1. #1
    chrishall is offline Junior Member Array
    Join Date
    Jul 2007
    Answers
    1

    Conditions or Calculation

    I'm trying to change the name of something already programmed into the system. Lets say in Coditions PAC = "I" and it will display "I" every time it is flagged in the system under PAC. How do I make it so "I" is displayed as something else like "Indigo"


  2. #2
    tprabhuit's Avatar
    tprabhuit is offline Junior Member Array
    Join Date
    Dec 2007
    Location
    Coimbatore
    Answers
    14
    Hi,

    You can use FORMAT column in the SQL prompt. Whereas in scripts it may not work.

    Regards,
    Prabhu.T


Latest Article

Network Security Risk Assessment and Measurement

Read More...