22. Display the order number, number of lines in the order,
total number of items and total value for all orders that
have a total value greater than $100


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

What are the basic element of Base configuration of an oracle Database ?

2 Answers  


What exactly do quotation marks around the table name do?

0 Answers  


How to define a sub function?

0 Answers  


Why we choose emp number as primarykey?

4 Answers  


How to define default values for formal parameters?

0 Answers  






What is trigger associated with the timer ?

1 Answers   Oracle,


What is archive log in Oracle?

0 Answers   MCN Solutions,


When system tablespace is created?

0 Answers  


Is a rollback possible to any savepoint?

0 Answers  


What is Rollback Segment ?

3 Answers  


Difference between the “verify” and “feedback” command?

0 Answers  


How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)