Can anyone plz let me know the output for this query?
select 1 from dual
minus
select 'a' from dual;
- 2 Answers
- 8346 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swati
This will produce Error
ORA-01790: expression must have same datatype as
corresponding expression
because 1 is number and a is string
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / abhishek rao maidarkar
Error.
To use MINUS or any other SET operators the
SELECT ...... clause should have same kind of variables.
| Is This Answer Correct ? | 1 Yes | 0 No |
is any oracle education partner in Bangalore?
I would like to know all the details about oracle certification on different levels.
16 Answers Algo, CMC, CybAge, HCL, IBM, Oracle, TCS, Zensar,
hi, i did ocp dba 9i in 2009 but not get job on oracle,now i want to continue my career as oracle dba what i do next .?
SQL>select 'yakub' pasha from dual; (what is the output and how it happen)
i required oracle HRMS certification material , if your friends or your colleagues have this material , then pl send me ... or either you find any where in website then send me links
Can you please send me the dups for the OCA certification?
hi i'm jhaniya i'm a fresher i've completed course in informatica and cognos but yet nw i din get a job ..so planning to study oracle will tis match ..even if i get placed in oracle can i then get into informatica wil this work out ..which part can i choose in oracle ..
I would like to know about Oracle Online Course certification (Finance)
Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?
where the bestone of the oracle certification tutorials in the hyderabad plz give me full contact address to my ramu.nani28@gmail.com thank you frnds
I have done GNIIT software engneering and B.COM and also i have 1yr exp in oracle DBA can i do oracle DBA certification plz adviced me frnds....as early possible with certification details...
1)Can Any body tell total no. of question in OCA and OCP? 2)Can i directly appear the OCP exam without attending OCA exam?
Cisco Certifications 
