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 5614I 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 3229Post New DB Administration Questions
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the default fill factor value? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
how can you connect from 10g user to 11g user??
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
who owns the operating system files created by the utl_file package?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you create a user-defined lock?