Database References
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';
Home
Subscribe to:
Comments (Atom)