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

im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions

0 Answers HCL,

hai what are the certification courses available in oralcle certification

1 Answers

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

1 Answers

Hi , I am planning to take up OCA certification.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 sajagporwal123@gmail.com.Please give me any tips if possible.

0 Answers

I would like to know all the details about oracle certification on different levels.

16 Answers Algo, CMC, CybAge, HCL, IBM, Oracle, TCS, Zensar,

being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me

0 Answers Wipro,

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

1 Answers

Dumps for 1z0-108 Weblogic server administration 11g or 1z0-102 Weblogic server administration 10g

1 Answers Cognizant, Verizon,

basically oracle i dont know .so what kind of courses and how to prepare and where to write a exams and fees detaile and it features sent to friends or sir or madam

2 Answers Oracle, Tech Mahindra,

how can i get oracle certifications logo?

2 Answers

I would like to know passing marks for oracle certification course module 1....

1 Answers

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

0 Answers TCS,

For more Oracle Certifications Interview Questions Click Here