How to Truncate Table in Oracle


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

What is MTTR advisor in Oracle?

0 Answers   MCN Solutions,


How to empty your oracle recycle bin?

0 Answers  


What is a Tablespace?

5 Answers  


what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,


How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,






what happened to the global index when I truncate the data in one of the partition?

0 Answers  


Select the Nth lowest value from a table?

4 Answers  


Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  


What is backup in Oracle?

0 Answers   MCN Solutions,


What is define in oracle?

0 Answers  


consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  


The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)