Can anyone plz let me know the output for this query?
select 1 from dual
minus
select 'a' from dual;
- 2 Answers
- 8117 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 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?
being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me
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,
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 .?
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.
What is the exam fees for oca,ocp,ocm certification course in Bangalore?
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.
I would like to know all the details about oracle certification on different levels.
16 Answers Algo, CMC, CybAge, HCL, IBM, Oracle, TCS, Zensar,
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.
Hello friends,can you explain basic difference between oracle and sql,dbms and rdbms
oracle what kind of certificate as valided in nowadays. how long during studied for this certificats.
what is the exact syllabus for oracle certification level 1?
Cisco Certifications 
