-
Conditional Statement
I have one table and any columns. One column is varchar2(50) and your value can be null or letters. My problem is, when I use SELECT Statement this column with LIKE '%', values equal NULL no apeears.
I can't do use this column is my WHERE clause.
Somebody know I resolve this problem ?
Victor Ramalho Peres
-
Hi
sample code to resolve your problem.
select * from emp
where nvl(ename,' ') like '%'
above query will retreive both ename with null values and values.
Thanks
-
This is work corretly.
Thanks of you help.
-
What about this?
select * from emp;
(fewer characters, anyhow)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|