4. Display the order number and client number from the ORDER
table. Output the result in the format. Client
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
3 385210. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
3 568311. Display the client number and name and the client number and name of the person who referred that client.
191814. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
1 487215. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
169916. Display the order number, order line number and the
shipping date. If the shipping date is null, display the
string
18. Display the clientno and total value for all orders
placed by that client. Output the result in the following
format: Client
Post New Wipro Oracle General Interview Questions
What flow of MSExcel in odi?
Why is spring boot used? : Spring Boot
Is spark sql similar to drill?
How would you do the 'setting up two grids in the planning book'.
how do you programme Carrier Sense Multiple Access
Explain the difference between alpha testing and beta testing.
if you are in a software company,then why do you want to come in a core company like sail, ntpc(where lots of trouble like tension but you have a good life in a it company) ?
Why do we use class?
Name some features of a secondary immune response that distinguish it from primary immune response
write a c program to find the sum of five entered numbers using an array named number
What are the differences between analytical and computational modeling?
How many number of columns can a RECORD GROUP have ?
How will you do the data migration in-case of any risk happens in your existing automation process?
What is the purpose of the registry?
What is paas?