select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;
Saturday, 26 July 2014
select duplicate records in oracle
Friday, 4 July 2014
Append comma in string end C#
string char1 = "";
for (int i = 0; i < ricmodel.TypeofCharacteristics.Length; i++)
{
if (string.IsNullOrEmpty(char1))
{
char1 = ricmodel.TypeofCharacteristics[i];
}
else
{
char1 = char1 + "," + ricmodel.TypeofCharacteristics[i];
}
}
for (int i = 0; i < ricmodel.TypeofCharacteristics.Length; i++)
{
if (string.IsNullOrEmpty(char1))
{
char1 = ricmodel.TypeofCharacteristics[i];
}
else
{
char1 = char1 + "," + ricmodel.TypeofCharacteristics[i];
}
}
Wednesday, 2 July 2014
Oracle Shut Downing Steps
> sqlplus /nolog
SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE Instance shut down.
SQL> startup nomount
ORACLE Instance started
SQL> alter database mount;
SQL> alter database open;
Which still gave the error:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt]
I then found the advice to do the following:
SQL> startup mount
ORACLE Instance started
SQL> recover database
Media recovery complete
SQL> alter database open
Database altered
SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE Instance shut down.
SQL> startup nomount
ORACLE Instance started
SQL> alter database mount;
SQL> alter database open;
Which still gave the error:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt]
I then found the advice to do the following:
SQL> startup mount
ORACLE Instance started
SQL> recover database
Media recovery complete
SQL> alter database open
Database altered
Oracle database import and export query
Oracle database dump file import query:
=========================================================
C:\>IMP FMS/FMS FILE=C:\users\nadamuni\desktop\fms.dmp FULL=Y
Oracle database dump file export query:
=========================================================
C:\>EXP FMS/FMS FILE=C:\users\nadamuni\desktop\fms.dmp
=========================================================
C:\>IMP FMS/FMS FILE=C:\users\nadamuni\desktop\fms.dmp FULL=Y
Oracle database dump file export query:
=========================================================
C:\>EXP FMS/FMS FILE=C:\users\nadamuni\desktop\fms.dmp
Oracle database drop all the tables ,stored procedures ,functions and sequences at a time query
BEGIN
FOR cur_rec IN (SELECT object_name, object_type
FROM user_objects
WHERE object_type IN
('TABLE',
'VIEW',
'PACKAGE',
'PROCEDURE',
'FUNCTION',
'SEQUENCE'
))
LOOP
BEGIN
IF cur_rec.object_type = 'TABLE'
THEN
EXECUTE IMMEDIATE 'DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '" CASCADE CONSTRAINTS';
ELSE
EXECUTE IMMEDIATE 'DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '"';
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( 'FAILED: DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '"'
);
END;
END LOOP;
END;
FOR cur_rec IN (SELECT object_name, object_type
FROM user_objects
WHERE object_type IN
('TABLE',
'VIEW',
'PACKAGE',
'PROCEDURE',
'FUNCTION',
'SEQUENCE'
))
LOOP
BEGIN
IF cur_rec.object_type = 'TABLE'
THEN
EXECUTE IMMEDIATE 'DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '" CASCADE CONSTRAINTS';
ELSE
EXECUTE IMMEDIATE 'DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '"';
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( 'FAILED: DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '"'
);
END;
END LOOP;
END;
Subscribe to:
Posts (Atom)