Can anyone plz let me know the output for this query?
select 1 from dual
minus
select 'a' from dual;
- 2 Answers
- 7892 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 |
i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?
what is the meaning of this query Alter database force logging.
What is the exam fees for oca,ocp,ocm certification course in Bangalore?
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.
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.
I would like to know about Oracle Online Course certification (Finance)
oracle what kind of certificate as valided in nowadays. how long during studied for this certificats.
Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;
i would like to know oracle dba on 10g/11i certification fee structure ..for all exams please help me
How to specify multiple value
Hi. I wish to appear for OCA exam. Can anyone pls guide me on the syllabus n fee structure of the exam. I know that there are 2 tracks : developer and dba. What is the difference between the two? All suggestions are welcome. Thanks.
Sir, what are the certification courses available in peoplesoft. I have completed my B.com (1991) and currently working in IT sector on peoplesoft financial module.where i can do this certification.
Cisco Certifications 
