Can anyone plz let me know the output for this query?
select 1 from dual
minus
select 'a' from dual;
- 2 Answers
- 7867 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 completed MCA and also I have OCA certification. Now I am working as a Application Developer in Asp.net but I need a job in Oracle Application or related to Sql or Pl/Sql.
explain procedure of the OCJP cerification, and exam fee please explain
Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;
hi, i did ocp dba 9i in 2009 but not get job on oracle,now i want to continue my career as oracle dba what i do next .?
hai what are the certification courses available in oralcle certification
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
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?
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
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.
Hi All..! This is Ratna,Im working as a Oracle apps Technical Consultant with 2yrs of experience.I started working on Hrms module,I feel like going for functional certification in HRMS module.Can any one suggest me on the below questions 1. how many papers are there for Oracle HRMS certification, and what is fees for each paper. 2. can a person pass the paper by reading the related documention provided by oracle. 3. do anybody have bunch of questons for oracle HRMS and like to share.
Can you pls tel me there is any certification for Peoplesoft hrms?
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,
Cisco Certifications 
