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 512410. 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 696111. Display the client number and name and the client number and name of the person who referred that client.
239114. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
1 565515. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
235716. 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
Define the term 'users' in openstack.
What is the command used to fetch first 5 characters of the string?
Tell me what is https/ssl update?
What is winword exe error?
What are switches? Explain the concepts of layer-3 switches?
Name some of the most common actuarial software used in industry?
What is the difference between memcpy and memmove?
on “sed” command EmpData(Sample Database) 1122|j.b. saxena |g.m. |account |12/12/52|6000 2233|n.k. gupta |d.g.m |sales |31/12/40|9000 4545|anil agarwal |director |account |06/07/47|7500 5656|lalit choudhury |executive|marketing|07/09/50|5000 1265|chanchal singhvi|g.m. |admin |12/09/63|6000 0110|shyam saksena |chairman |marketing|12/12/43|8000 5566|jai sharma |director |account |23/12/89|7000 7733|jayant |d.g.m |sales |29/02/70|6000 1. From the above database substitute the delimiter of first 3 lines with “ : “ 2. From the above database substitute the delimiter with “ : ” 3. Insert the string “ XYZ Employees” in the first line. 4. Store the lines pertaining to the directors, d.g.m and g.m into three separate files. 5. Using address store first 4 lines into a file Empupdate. 6. Find the pattern “account” in the database and replaces that with “accounts”. 7. Select those lines which do not have a pattern “g.m”. 8. Insert a blank line after every line in the database.
What is looping and how to avoid it in framework manager?
What number ranges can be configured in srm ?
What companies are working on Internet of Things (IoT)?
What does rownum mean in sql?
How do I compare two strings in excel?
what is the difference between window & document in javascript?
Is it possible to create web application with both webforms and mvc?