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 6725I 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 3962Post New DB Administration Questions
What purpose does the model database server? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
what are the differences of where and if in SAS?
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.
what is grd?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is replication? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you schedule a job in database?
Can you redefine a table online?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Why would you use sql agent? : sql server DBA