1. Display all the rows and columns in the CLIENT table.
Sort by client name in reverse alphabetical order.
Answers were Sorted based on User's Feedback
Answer / yogesh sharma
select * from emp order by reverse(ename) ;
| Is This Answer Correct ? | 6 Yes | 3 No |
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
How to drop a stored function?
What is a OUTER JOIN?
What is COST-based approach to optimization ?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
How a tablespace is related to data files?
What is a relational database management system?
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
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is the database name in oracle?
What are the commands youd issue to show the explain plan for select
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.