Can anyone plz let me know the output for this query?
select 1 from dual
minus
select 'a' from dual;
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 |
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
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.
hai what are the certification courses available in oralcle certification
hi i'm jhaniya i'm a fresher i've completed course in informatica and cognos but yet nw i din get a job ..so planning to study oracle will tis match ..even if i get placed in oracle can i then get into informatica wil this work out ..which part can i choose in oracle ..
Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;
hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details
i have 6 years of gap after doing bca. how to get a good job now.
Can you pls tel me there is any certification for Peoplesoft hrms?
Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)
SQL>select 'yakub' pasha from dual; (what is the output and how it happen)
What is the default value of Boolean Operator? a.Null b.True c.False d.none of the above
15 Answers CTS, Infosys, Wipro,
I would like to know all the details about oracle certification on different levels.
16 Answers Algo, CMC, CybAge, HCL, IBM, Oracle, TCS, Zensar,