Monday, 7 November 2011

Getting Date from Oracle, MS SQL Server and IBM DB2 using dummy table

SELECT getDate(); -- MS SQL Server


SELECT sysdate FROM dual; --Oracle


SELECT current date FROM sysibm.sysdummy1; -- DB2

RENAME TABLE

MS SQL SERVER :
    EXEC SP_RENAME 'OLD_TABLE_NAME' , 'NEW_TABLE_NAME';

ORACLE :
    RENAME 'OLD_TABLE_NAME' TO 'NEW_TABLE_NAME';
DB2 :
    RENAME TABLE 'OLD_TABLE_NAME' TO 'NEW_TABLE_NAME';