1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
2 6032I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
1 3532Post New DB Administration Questions
How would you extract DDL of a table without using a GUI tool?
What is fill factor? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
who owns the operating system files created by the utl_file package?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the steps you will take to improve performance of a poor performing query?
what are the differences of where and if in SAS?
How do you open a cluster administrator? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you connect from 10g user to 11g user??
Explain about your sql server dba experience? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA