Can anyone plz let me know the output for this query? select 1 from dual minu

Can anyone plz let me know the output for this query?
select 1 from dual
minus
select 'a' from dual;

Question Posted / akila

2 Answers
8932 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can anyone plz let me know the output for this query? select 1 from dual minus select 'a�..

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

Can anyone plz let me know the output for this query? select 1 from dual minus select 'a�..

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

Post New Answer

More Oracle Certifications Interview Questions

What is the exam fees for oca,ocp,ocm certification course in Bangalore?

1 Answers Oracle,

I am an engineering student and this is my final year. so i m planing of doing OCA certification course. is this time good? are there future scope for it?

0 Answers IBM, Oracle,

how can i get oracle certifications logo?

2 Answers

I am an engineering student and this is my final year. so i m planing of doing OCA certification course. is this time good? are there future scope for it?

1 Answers Oracle,

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

0 Answers

Hi , I am planning to take up OCA certification in next 3 months.Can you please provide me with the path for Oracle DBA certi.If any one of you have dumps for same,please mail them to mukund.kanabargi@gmail.com.Please give me any tips if possible.

1 Answers

Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?

0 Answers

i would like to know oracle dba on 10g/11i certification fee structure ..for all exams please help me

3 Answers CTS, Oracle,

Hi guys, I want to clear exams of OCA and informatica developer (three papers).......Could you all plz help me and send me the dumps for the same...Thanks in advance!!!!

0 Answers

I am planing for sql exam so please help me about exam questions.

1 Answers

i have 6 years of gap after doing bca. how to get a good job now.

0 Answers IBM,

I would like to know about Oracle Online Course certification (Finance)

0 Answers Accenture,

For more Oracle Certifications Interview Questions Click Here