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
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
which sql command we can use to get a print out from oracle?
What are the extensions used by oracle reports?
What is an oracle function?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What are the different pseudo commands? Explain in general?
difference between truncate and delete ,drop?
What is an oracle cursor variable?
How many categories of data types?
Explain the use of full option in exp command.