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 6542I 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 3856Post New DB Administration Questions
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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 are the different types of upgrades that can be performed in sql server? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is the diffrence between core dba and apps dba?
what are the differences of where and if in SAS?
What is the difference between clustered and non-clustered index? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you create a user-defined lock?
what is a user-defined lock?
what is asm?
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.
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you implement fine-grained auditing?