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
8923 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

hai, i think to do certification in oracle 11i. Can any one help me regarding fee, duration , preparation, and how much it is use full for getting a good job.

0 Answers

SQL>select 'yakub' pasha from dual; (what is the output and how it happen)

3 Answers

what is the exact syllabus for oracle certification level 1?

0 Answers

sir plse tell me oracle 10g ocp certification material and previous papers send to me

1 Answers

Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..

0 Answers BirlaSoft,

How to prepare for doing OCA and is there books or any model questions or any site which helps us fro preparing our own? Please give me the complete information if possible.

2 Answers

What is the default value of Boolean Operator? a.Null b.True c.False d.none of the above

15 Answers CTS, Infosys, Wipro,

I am willing to go for General Ledger certification. Could any one guide me what are the prerequisites..? am i need to any exam before take this GL exam..?

1 Answers

Hi, I am doing mba hr and having 4.4 yrs experience in marketing research and accounts payable together. Now i have 2 yrs of carrier break. Will it be advisable to do oracle hrms certification and grab new opportunities?

0 Answers

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

1 Answers

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

1 Answers Oracle,

I have b licence . I want c licenc. What can i do it. I have 5 years HT experience .

0 Answers TNEB Tamil Nadu Electricity Board,

For more Oracle Certifications Interview Questions Click Here