1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

The in operator may be used if you know the exact value you want to return for at least one of the columns.

Question Posted / ankur aggarwal


The in operator may be used if you know the exact value you want to return for at least one of the c..

Answer / Sanjay Khurana

The IN operator is used with a list of values to check whether a column's value matches any of the listed values. It can simplify queries when you need to compare a single column against multiple possible values.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

what are the advantages and disadvantages of views in a database? : Sql dba

1 Answers  

How do you truncate?

1 Answers  

Can you have more than one trigger on a table?

1 Answers  

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

What is sqlerrd?

1 Answers  

what is self join and how it works??

2 Answers   Infosys,

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

What is the difference between function, procedure and package in pl/sql?

1 Answers  

Is ms sql is free?

1 Answers  

how to connect oracle in unix prompt?

4 Answers   Polaris,

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

For more SQL PLSQL Interview Questions Click Here
Categories