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

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

0 Answers Accenture,

oracle what kind of certificate as valided in nowadays. how long during studied for this certificats.

1 Answers Oracle,

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

1 Answers

HI, I have completed my M.com and MBA and currently working in IT sector in HR Recruitment. i just want to do Oracle HRMS functional course. And is there is any study center in Coimbatore from where i can do this certification.

0 Answers

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

0 Answers IBM,

HI, I have completed my B.com and MBA and currently working in IT sector in HR Recruitment. i just wanted to know Oracle HRMS course is technical or functional. And is there is any study center in Noida from where i can do this certification.

2 Answers

Which one is the best institute in Noida or in Delhi NCR from where i can pursue Oracle HRMS course. Pls. provide me the details

1 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?

0 Answers IBM, Oracle,

is any oracle education partner in Bangalore?

5 Answers

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

0 Answers HCL,

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

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,

For more Oracle Certifications Interview Questions Click Here