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 5596I 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 3219Post New DB Administration Questions
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What is the default fill factor value? : sql server DBA
when does an alert gets signaled?
What is fill factor? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the different types of upgrades that can be performed in sql server? : 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.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what do you understand by flashback feature of oracle?
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 role of dip user in our database?
What purpose does the model database server? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?