Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

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

0 Answers   HCL,


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.

1 Answers  


hai what are the certification courses available in oralcle certification

1 Answers  


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

3 Answers  


Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;

2 Answers  


hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details

0 Answers  


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

0 Answers   IBM,


Can you pls tel me there is any certification for Peoplesoft hrms?

1 Answers  


Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)

0 Answers   Oracle,


SQL>select 'yakub' pasha from dual; (what is the output and how it happen)

3 Answers  


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,


Categories
  • Cisco Certifications Interview Questions Cisco Certifications (2321)
  • Microsoft Certifications Interview Questions Microsoft Certifications (171)
  • Sun Certifications Interview Questions Sun Certifications (45)
  • CISA Certification Interview Questions CISA Certification (744)
  • Oracle Certifications Interview Questions Oracle Certifications (64)
  • ISTQB Certification Interview Questions ISTQB Certification (109)
  • Certifications AllOther Interview Questions Certifications AllOther (295)