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
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to convert csv to table in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the difference between sharding and partitioning?
How to create a single index for multiple columns?
master table and child table performances and comparisons in Oracle ?
What are data pump export and import modes?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is the quickest way to export a table to a flat file?
How to drop an existing table in oracle?
How to estimate disk space needed for an export job?
List the types of joins used in writing subqueries?
What to do if the binary spfile is wrong for the default instance?