how to use comma separated value list in the where clause oracle

how to use comma separated value list in the where clause oracle

Hi,

how to use comma separated value list in the where clause oracle

Thanks

View Answers

October 10, 2017 at 9:51 PM

HI,

Following code will help you:

select * from employee where id in (
   select regexp_substr('1,2,3,4','[^,]+', 1, level) from dual
   connect by regexp_substr('1,2,3,4', '[^,]+', 1, level) is not null 
   );

Thanks


October 10, 2017 at 9:51 PM

HI,

Following code will help you:

select * from employee where id in (
   select regexp_substr('1,2,3,4','[^,]+', 1, level) from dual
   connect by regexp_substr('1,2,3,4', '[^,]+', 1, level) is not null 
   );

Thanks


October 10, 2017 at 9:52 PM

HI,

Following code will help you:

select * from employee where id in (
   select regexp_substr('1,2,3,4','[^,]+', 1, level) from dual
   connect by regexp_substr('1,2,3,4', '[^,]+', 1, level) is not null 
   );

Thanks









Related Tutorials/Questions & Answers:
how to use comma separated value list in the where clause oracle
how to use comma separated value list in the where clause oracle  Hi, how to use comma separated value list in the where clause oracle Thanks   HI, Following code will help you: select * from employee where id
Java arraylist to comma separated string
arrayList is converted into the comma separated string. For this take one.... Example of Java Arraylist Comma Separated String import java.util.ArrayList... ar[]={1,2,3,4};      ArrayList list=new ArrayList();      list.add(ar[0
Advertisements
HOW CN I USE WHERE AND BETWEEN CLAUSE SIMULTANEOUSLY... IN MYSQL
HOW CN I USE WHERE AND BETWEEN CLAUSE SIMULTANEOUSLY... IN MYSQL  sir, how can i use WHERE and BETWEEN clause simultaneously..? my tables details... WHERE _exp_date BETWEEN ('2009-07-01' AND '2011-07-30') AND _exp_for_id = 1
Explain the use of the ‘LIKE’ keyword used in the WHERE clause?
Explain the use of the ?LIKE? keyword used in the WHERE clause?   Explain the use of the ?LIKE? keyword used in the WHERE clause
Explain the use of the ‘LIKE’ keyword used in the WHERE clause?
Explain the use of the ?LIKE? keyword used in the WHERE clause?   Explain the use of the ?LIKE? keyword used in the WHERE clause
Where clause
Where clause  I have doubt in Where clause .. i got a Employid from...; The WHERE clause is used to filter records.It is used to extract only those..._name(s) FROM table_name WHERE column_name = value; Example: In the given
JDBC: WHERE Clause Example
JDBC: WHERE Clause Example In this section, we will discuss how to use WHERE... static void main(String[] args) { System.out.println("Use of WHERE Clause.... WHERE Clause : MySql Where Clause is used to write some condition and data
Hibernate WHERE Clause
Hibernate WHERE Clause In this tutorial you will learn how to use HQL where clause. Use of WHERE clause in hibernate is as same as it used in SQL... will demonstrate you how a HQL where clause can be used. To achieve the solution
Where Clause in SQL
The Tutorial illustrate an example from where clause in SQL. In this Tutorial we use... Where Clause in SQL       The Where clause in SQL query is used  with the SELECT keyword
where clause in select statement
where clause in select statement  In Mysql,I write the following query: select * from emp where designation = "MANAGER" But the actual value... nly if the where condition is "manager" and not "MANAGER
Where and Having clause
Where and Having clause   hii, What is the difference between where and having clause?   hello,ADS_TO_REPLACE_1 WHERE clause is used... before GROUP BY clause. HAVING clause is used to impose condition on GROUP
Where clause with query in MySQL
Where clause with query in MySQL  Hi, I want to learn the where... is the various example of where clause: Suppose we have following table: mysql> select... (0.00 sec) Following shows more uses of where clause: mysql> select * from
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?  What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?   Hi, Both HAVING and WHERE clause used for specifying the search condition in SQL
SQL Aggregate Functions In Where Clause
in the 'Stu_Name'. In order to overcome, we use the WHERE clause. The Syntax... SQL Aggregate Functions In Where Clause       SQL Aggregate Function In Where Clause return
Mysql Date in where clause
Mysql Date in where clause     ... records from table employee1 on the basis of condition specified in WHERE clause... Mysql data in Where clause. The given Query create table employee1 is used
Explain the use of the ?LIKE? keyword used in the WHERE clause? Explain wildcard characters in SQL.
Explain the use of the ?LIKE? keyword used in the WHERE clause? Explain wildcard characters in SQL.  Explain the use of the ?LIKE? keyword used in the WHERE clause? Explain wildcard characters in SQL
Explain the use of the ‘LIKE’ keyword used in the WHERE clause? Explain wildcard characters in SQL.
Explain the use of the ?LIKE? keyword used in the WHERE clause? Explain wildcard characters in SQL.  Explain the use of the ?LIKE? keyword used in the WHERE clause? Explain wildcard characters in SQL
PHP SQL Query Where Clause
PHP SQL Query Where Clause       This example illustrates how to create and execute the sql query with where clause. To understand how to display the result returned 
HQL Where Clause Example
HQL Where Clause Example       Where Clause is used to limit the results returned from... lngInsuranceId='1'ADS_TO_REPLACE_1 Where Clause can be used with or without Select
Using WHERE Clause in JDBC
Using WHERE Clause in JDBC    Where... conditions. It allows to filter the data from a table, a WHERE clause can be added to the SELECT statement. The WHERE clause searches the specific results
how to use dropdown list in JSP and display value in same page
how to use dropdown list in JSP and display value in same page  I have a Dropdown list with some values say "A", "B" and "C" When the user selects... in the same page Value selected = C How can we do this in a JSP page
how to create a bar chart in jsp by fetching value from oracle databse?
how to create a bar chart in jsp by fetching value from oracle databse?  i want to show the population of various states in a bar chart in my jsp page by fetching the data from my oracle table. i am using my eclipse as my IDE
What is the difference between IN and BETWEEN, that are used inside a WHERE clause?
inside a WHERE clause?   Hi, The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified...What is the difference between IN and BETWEEN, that are used inside a WHERE
how to set value of dropdown list
how to set value of dropdown list  Hello Sir, I'd solved the earlier problems somehow but now this time another problem arised when I want to pass the value from a link to a dropdown list. I want to set the dropdown list selected
how to set value of dropdown list
how to set value of dropdown list  Hello Sir, I'd solved the earlier problems somehow but now this time another problem arised when I want to pass the value from a link to a dropdown list. I want to set the dropdown list selected
SQL Aggregate Functions Where Clause
SQL Aggregate Functions Where Clause       SQL Aggregate Functions Where Clause return you the aggregate sum of the records based on the condition specified in Where Clause condition
JPA Query with where clause and group by function
JPA Query with where clause and group by function  Any thing wrong in my JPA Query. TypedQuery<RaBdrRating> uQuery = (TypedQuery<...(charge),COUNT(activePackage) FROM User WHERE callType = :callType and startDate
Php Sql Where
Php Sql Where This example illustrates how to use the WHERE clause in the UPDATE query in PHP. In this example we create a UPDATE query with WHERE clause to update the field emp_name where name is 'amar'. In the figure below the first
PHP WHERE clause example to fetch records from Database Table
different actions in MYSQL Database Tables. PHP WHERE Clause is one of them. We can use the WHERE clause in PHP & MYSQL to  add, edit or delete... the WHERE Clause in PHP. Here is an example of how you can write the WHERE Clause
SQL Aggregate Functions Where Clause
SQL Aggregate Functions Where Clause       SQL Aggregate Functions Where Clause is used... Aggregate Function Where Clause. To understand and grasp example we create a table
How to split string in Java using comma?
How to split string in Java using comma?  Hi, Share the example code for splitting the string in Java using comma as separator. Thanks   Hi, You can use the split() function of the String class to split the string
MySQL Case In Where Clause
MySQL Case In Where Clause       This example illustrates how to use case statement where clause... 'case' and 'where' clause: SELECT daysName, CASE daysName    WHEN
related retrieving value from oracle database
related retrieving value from oracle database  how we get the value from database in the given textbox
related retrieving value from oracle database
related retrieving value from oracle database  how we get the value from database in the given textbox
how to load value in dropdown list after selecting value from first dropdown list using javascript
how to load value in dropdown list after selecting value from first dropdown list using javascript  how to load value in dropdown list after selecting value from first dropdown list using javascript
WHERE Statement in SQL
WHERE Clause in SQL        WHERE clause is used with the SELECT keyword. ' Where' is a clause which is used for searching the data with a particular condition.  
I need Oracle connector jar file. where will i download?
I need Oracle connector jar file. where will i download?  I need Oracle connector jar file. where will i download
How to automatically change the value of the textbox based on the dropdown list?
How to automatically change the value of the textbox based on the dropdown list?  I want to know how to automatically change the value of price...="text" name="cus" required="required" value="" size=20px/></td> <
how to download oracle 9i
how to download oracle 9i  how to download oracle 9i
PHP Comma vs Period - PHP
PHP Comma vs Period  Explain PHP Comma vs Period. And also how can one show a comma within a comma separated file.   Hi Friend, Please visit the following link: http://www.roseindia.net/tutorial/php/phpbasics/PHP
How to use Bean Area in Oracle Forms 9i with Sample code ?
How to use Bean Area in Oracle Forms 9i with Sample code ?  Hi friend.I posted a query,but I didn't get the answer for it.Help me to resolve including a bean area in oracle forms 9i and using it in forms.Thanks in advance.Help me
Parsing Character-Separated Data with a Regular Expression
of words from where the comma or and|or separation is used. The complete separate word... Parsing Character-Separated Data with a Regular Expression       This section illustrates you how
MySQL Select Statement
;  In this lesson you will be learn how to use SELECT statement in MySQL and you can also learn how to use SELECT statement with WHERE... a comma separated list of column names. By the following example you select Name
insert excel value in to oracle data base
insert excel value in to oracle data base  Hi All I am using this code for saving excel value to oracle database table. code is working properly... then how excel data will mapp to oracle database table. My project requrement
Where can I start learning how to use TensorFlow?
Where can I start learning how to use TensorFlow?  Hi, TensorFlow is becoming programming language of choice among data scientist. I also want to learn TensorFlow. Where can I start learning how to use TensorFlow? Thanks
Where can I start learning how to use TensorFlow?
Where can I start learning how to use TensorFlow?  Hi, I have... trying to find best tutorials of TensorFlow on Internet. Where beginner should start learning TensorFlow? Where can I start learning how to use TensorFlow
how to insert list box in java script dynamically and elements retrieving from database like oracle
how to insert list box in java script dynamically and elements retrieving from database like oracle  Hi, how to dynamically increase size of list... insert new course in a table.. It should be seen in my list box..ADS
how to insert list box in java script dynamically and elements retrieving from database like oracle
how to insert list box in java script dynamically and elements retrieving from database like oracle  hi all, how can i insert elements into java script list box retrieving from Database. whenever I insert any element in the Db
JDBC: LIKE Clause Example
JDBC: LIKE Clause Example In this section, you will learn how to use LIKE... Clause is used for comparing part of string. For pattern matching we use...){ System.out.println("Use of LIKE Clause in JDBC..."); Connection con = null
Mysql Where
Clause. The Where Clause restricts the select query and shows you only the records specified in the Where Clause conditions. Understand with ExampleADS... (0.01 sec) Query for using where clause:ADS_TO_REPLACE_4

Ads