Home » SQL & PL/SQL » SQL & PL/SQL » Does not exist (oracle 10g)
Does not exist [message #618683] Mon, 14 July 2014 18:54 Go to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
create table Test(name varchar2(10),process varchar2(5), flag varchar(1));
insert into table values ('TEST1','A','Y');
insert into table values ('TEST1','B','Y');
insert into table values ('TEST1','C','Y');

insert into table values ('TEST2','A','Y');
insert into table values ('TEST2','B','Y');
insert into table values ('TEST2','C','N');

insert into table values ('TEST3','A','Y');
insert into table values ('TEST3','B','Y');
insert into table values ('TEST3','C','Y');

insert into table values ('TEST4','','');
insert into table values ('TEST4','B','Y');
insert into table values ('TEST4','C','Y');



My requirement is if
1)flag column is 'N' then I have to display falg is N for TEST2.
2) if flag and process null then I have to display flag(Y) and process(C) is not exist for TEST4.
Re: Does not exist [message #618685 is a reply to message #618683] Mon, 14 July 2014 19:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://docs.oracle.com/cd/E16655_01/server.121/e17209/functions126.htm#SQLRF00684
Re: Does not exist [message #618708 is a reply to message #618683] Tue, 15 July 2014 00:26 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Your requirements are not clear and can be interpreted in several ways, gave them WITHOUT referring to the data you give (that is without mentioning TEST2, TEsT4...).
Always post what should be the result for the data you give.

[Updated on: Tue, 15 July 2014 00:29]

Report message to a moderator

Previous Topic: Sql Query to see the sales between dates
Next Topic: Execute immediate
Goto Forum:
  


Current Time: Sat Mar 30 01:46:43 CDT 2024