Answer Posted / vsubbaiah
Select Distinct |fields * | from table name
where condition
group by column list
having grouped column
order by column
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is there any function in oracle similar like group_concat of mysql?
Explain index?
How to convert a string to a date in oracle database?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to get a create statement for an existing table?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What are a query and state the different types of queries and their uses?
What are the restrictions in a oracle read only transaction?
How to run create database statement again?
What is Library Cache in Oracle?
What is varray?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How a tablespace is related to data files?
How can you merge two tables in oracle?
How to turn on or off recycle bin for the instance?