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 6023I 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 3517Post New DB Administration Questions
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 are the different types of indexes available in sql server? : sql server DBA
What are the commands used in dcl? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you communicate with operating system files from oracle?
Explain materialized views and how they are used.
what do you understand by flashback feature of oracle?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How would you go about verifying the network name that the local_listener is currently using?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
who owns the operating system files created by the utl_file package?
what is the diffrence between core dba and apps dba?