3. Display all the client numbers in the ORDER table. Remove
duplicates.



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

Post New Answer

More Oracle General Interview Questions

What does `(+)` do in a where clause?

1 Answers  


Does oracle partitioning improve performance?

1 Answers  


How to check the oracle tns settings?

1 Answers  


What is use of oracle?

2 Answers   Satyam,


How to bring a tablespace offline?

1 Answers  


How to increment dates by 1 in oracle?

1 Answers  


Why use resource manager in Oracle?

1 Answers   MCN Solutions,


What is a cursor in oracle?

1 Answers  


how can we store any pdf file in oracle

1 Answers  


What is the purpose of a cluster?

1 Answers  


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1 Answers   Oracle,


T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)