Home » SQL & PL/SQL » SQL & PL/SQL » Checking for null in Nested table column
Checking for null in Nested table column [message #217994] Tue, 06 February 2007 05:32 Go to next message
manojg99
Messages: 1
Registered: February 2007
Junior Member
Hi,
I 've created a table with 3 columns and one of them is nested table of varchar2.

create type ntb_a3 as table of varchar2(16)

table xyz
columns :
a1 varchar2
a2 varchar2
a3 nested table column of varchar2

There is no primary key or index defined on table.

I've inserted 2 rows in the table .
First row insert values in column a3 as ('zz1','zz2')
insert into xyz(a1,a2)
values('bb','ss',ntb_a3('n1','n2'))
second row does not insert in column a3.
insert into xyz(a1,a2)
values('bb','ss')

I want to know the exact query to check if a row exists in table xyz with
a1 = 'bb' and a2 ='ss' and a3 is null

Re: Checking for null in Nested table column [message #218043 is a reply to message #217994] Tue, 06 February 2007 09:33 Go to previous message
srinivnp
Messages: 136
Registered: January 2006
Location: stlouis MO USA
Senior Member


select * from xyz where
a1 = 'bb' and a2 ='ss' and a3 is null ;

Srini

Previous Topic: time dimension loading week startign from saturday
Next Topic: ORA-00904: "ROWID" invalid identifier
Goto Forum:
  


Current Time: Mon Dec 05 19:02:41 CST 2016

Total time taken to generate the page: 0.05381 seconds