목록DB (158)

develog

[Oracle] 중복 데이터 제거

SELECT ROWID, C.*--DELETEFROM AATEST CWHERE C.ROWID IN ( SELECT B.ROWID FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY TITLE ORDER BY REG_TS) RNUM, ROWID, A.* FROM AATEST A ) B WHERE RNUM = 2);
DB/Oracle 2017. 6. 13. 12:10
[MSSQL] date

SELECT GETDATE()SELECT SYSDATETIME()SELECT CAST(GETDATE() AS DATE)SELECT CONVERT(CHAR(8), SYSDATETIME(), 112)SELECT CONVERT(DATETIME, CONVERT(CHAR(8), SYSDATETIME(), 112))
DB/MSSQL 2017. 5. 26. 12:27
[Oracle] 컬럼 순서 변경

CREATE TABLE TB_AA_TMP ASSELECT COL3, COL2, COL1FROM TB_AA; DROP TABLE TB_AA; RENAME TB_AA_TMP TO TB_AA;
DB/Oracle 2017. 4. 28. 18:07
[Oracle] index 비활성

ALTER INDEX IDX_01 UNUSABLE;ALTER INDEX IDX_01 REBUILD; SELECT INDEX_NAME, TABLE_NAME, STATUSFROM USER_INDEXESWHERE INDEX_NAME = 'IDX_01';
DB/Oracle 2017. 4. 28. 14:38
[DB] DB version

Oracle SELECT BANNER FROM V$VERSION WHERE ROWNUM = 1 MS-SQL SELECT @@VERSION MySQL SELECT VERSION()
DB/DB common 2017. 4. 25. 16:35
[MySQL] insert all

INSERT INTO AATEST (SEQ, TITLE) VALUES (1, '11'), (2, '22'), (3, '33') ;
DB/MySQL 2017. 4. 13. 17:15
Prev 1 2 3 4 5 6 ··· 27 Next