| Minus query with string values (merged) [message #648067] |
Tue, 16 February 2016 00:38  |
 |
Devmunat
Messages: 6
Registered: June 2014
|
Junior Member |
|
|
Hi,
Can we use minus query with string values directly instead of using columns in select dual statement?
For example.
SELECT 'ABC','DEF','GHI','IJHK' FROM DUAL
MINUS
SELECT 'GHI','IJHK' FROM DUAL;
-----------------------
Expected Output: 'ABC','DEF'
If i run this query i will get query has incorrect number of blocks error.
Is there any way where I can use string values minus approach directly in select dual statement ?
Thanks in advanced.
|
|
|
|
|
|
| Re: Minus query with string values (merged) [message #648112 is a reply to message #648067] |
Tue, 16 February 2016 13:06  |
 |
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
SCOTT@orcl> CREATE OR REPLACE TYPE varchar2_tt AS TABLE OF VARCHAR2(4000)
2 /
Type created.
SCOTT@orcl> SELECT varchar2_tt ('ABC','DEF','GHI','IJHK')
2 MULTISET EXCEPT
3 varchar2_tt ('GHI','IJHK')
4 FROM DUAL
5 /
VARCHAR2_TT('ABC','DEF','GHI','IJHK')MULTISETEXCEPTVARCHAR2_TT('GHI','IJHK')
--------------------------------------------------------------------------------
VARCHAR2_TT('ABC', 'DEF')
1 row selected.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
