3. Display all the client numbers in the ORDER table. Remove
duplicates.
Answer / aswini
select distinct client_number from <table_name>;
| Is This Answer Correct ? | 4 Yes | 0 No |
What do you mean by a tablespace?
What privilege is needed for a user to create views in oracle?
Does rowid change in oracle?
What is oracle data type?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
How do I escape a reserved word in oracle?
What is a database schema in oracle?
How to install oracle odbc drivers?
How to define default values for formal parameters?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
How to apply filtering criteria at group level in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?