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?????
Answer Posted / anil kumar prajapati
1. DELETE FROM
table_name A
WHERE
a.rowid >
ANY (
SELECT
B.rowid
FROM
table_name B
WHERE
A.col1 = B.col1
AND
A.col2 = B.col2
);
2.CREATE TABLE table_name
(
column1 datatype null/not null,
column2 datatype null/not null,
...
CONSTRAINT constraint_name PRIMARY KEY (column1, column2,
... column_n)
);
3.ALTER TABLE <TABLE NAME to be moved> MOVE TABLESPACE
<destination TABLESPACE NAME>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you enable flashback feature?
internal architecture
what do you understand by fine-grained auditing?
Why would you call update statistics? : sql server DBA
how can a session indicate its interest in receiving alerts?
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.
how can you connect from 10g user to 11g user??
How to start SQL Server in minimal configuration mode?
How do you trace the traffic hitting a sql server? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what is the diffrence between core dba and apps dba?
what is a user-defined lock?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?