Applying filters in the custom column in oracle
I have a query like this. I would like to filter with column Name "A.
select 'DummyValue1' as ColumnNameA from TableT.
Now i would like to apply filter like
select 'DummyValue1' as ColumnNameA from TableT where ColumnNameA =
"Value1" .
How do i do it in Oracle.
Please note here 'DummyValue1' as ColumnNameA is not actuallya data base
column. I am just creating in my result set.
No comments:
Post a Comment