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 5577I 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 3211Post New DB Administration Questions
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is the diffrence between core dba and apps dba?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you implement fine-grained auditing?
what are the types of connection load-balancing?
How to start SQL Server in minimal configuration mode?
What would you do with an "in-doubt" distributed transaction?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is replication? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : 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.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
You create a private database link and upon
connection, fails with: ORA-2085: connects to