Home » SQL & PL/SQL » SQL & PL/SQL » qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/)
qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/) [message #664845] Tue, 08 August 2017 08:41 Go to next message
mlashin
Messages: 3
Registered: August 2017
Junior Member
please i need to know the meaning of values of field (qualification_ind IN (4, 6, 20, 22))

thanks
qualification_ind value meaning [message #664847 is a reply to message #664845] Tue, 08 August 2017 08:47 Go to previous messageGo to next message
mlashin
Messages: 3
Registered: August 2017
Junior Member
please i need to know the meaning of values of field (qualification_ind IN (4, 6, 20, 22. etc))

thanks
Re: Performance issue on this query [message #664855 is a reply to message #664845] Tue, 08 August 2017 12:42 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Why do YOU need to know that? It was asked by the OP over 10 years ago.
Re: qualification_ind value meaning [message #664857 is a reply to message #664847] Tue, 08 August 2017 12:53 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Question does not compute.
Re: Performance issue on this query [message #664858 is a reply to message #664855] Tue, 08 August 2017 14:37 Go to previous messageGo to next message
mlashin
Messages: 3
Registered: August 2017
Junior Member
I face problem related to qualification_ind value the record value was null but after problem value changed to number 2
So i need to know what the value for this field rested to ant thing
Thanks
Re: Performance issue on this query [message #664859 is a reply to message #664858] Tue, 08 August 2017 15:04 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I'm sorry, I just do not understand. You have no punctuation and the words seem disjointed.
Re: qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/) [message #664999 is a reply to message #664845] Wed, 16 August 2017 20:47 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
mlashin wrote on Tue, 08 August 2017 06:41
please i need to know the meaning of values of field (qualification_ind IN (4, 6, 20, 22))

thanks

It looks like this is part of a select query, like:

select * from your_table 
where  qualification_ind IN (4, 6, 20, 22);

If this is the case, the it is telling the query to limit the rows returned to those where the column named qualification_ind is one of those four values in the in clause. It would be the same as:

select * from your_table 
where  qualification_ind = 4
or     qualification_ind = 6
or     qualification_ind = 20
or     qualification_ind = 22;

Using an IN clause shortens the code.


Previous Topic: MISSING DATE
Next Topic: Determine filePath/Name from UTL_FILE.FILE_TYPE?
Goto Forum:
  


Current Time: Thu Mar 28 19:45:34 CDT 2024