Select 'X'

[aumstu]

This may not post as a good question because it may be to vague..but I will give it a shot...

I am trying to figure out some code that is in PL/SQL...In some of the sql statements that use

Select 'X' from dual where fieldname = :ID

what is Select X? I have tried this out...but it returns the character X in one column.

Could anyone help explain this please?

 

[SantaMufasa]

Stu,

To understand the function/benefit of the above statement, it needs to appear in context. Could you please place some "flesh" around your query by posting either the block of PL/SQL code, or (if the block is too large) at least the "IF" statement or loop in which (I'm presuming) this SELECT appears.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.