목록DB (158)

develog

[Oracle] timestamp to date

SELECT CAST(SYSTIMESTAMP AS DATE) FROM DUAL
DB/Oracle 2017. 4. 3. 10:37
[Oracle] Function return table

1. 생성 -- 1. OBJECT 타입 생성CREATE OR REPLACE TYPE T_OBJ AS OBJECT ( COL1 VARCHAR2(10) , COL2 VARCHAR2(10) ); -- 2. TABLE 타입 생성CREATE OR REPLACE TYPE T_TABLE AS TABLE OF T_OBJ; -- 3. 함수 생성 (테이블 리턴) CREATE OR REPLACE FUNCTION TFN_LIST(P_COL1 VARCHAR2) RETURN T_TABLE IS V_RTN T_TABLE; BEGIN SELECT T_OBJ(COL1, COL2) BULK COLLECT INTO V_RTN FROM ( SELECT COL1, COL2 FROM MY_TABLE WHERE COL1 = P_COL1 ); R..
DB/Oracle 2017. 3. 27. 13:52
[Oracle] 참조 찾기

SELECT * FROM ALL_DEPENDENCIES WHERE REFERENCED_OWNER = '' AND REFERENCED_NAME = ''
DB/Oracle 2017. 3. 27. 10:34
[DB] DDL, DML, DCL

DDL (Data Definition Language)CREATE DROP ALTER TRUNCATE COMMENT RENAME DML (Data Manifulation Language)SELECT INSERT UPDATE DELETE MERGE CALL EXPLAIN PLAN LOCK TABLEDCL (Data Control Language)GRANT REVOKETCL (Transaction Control Language)COMMIT ROLLBACK SAVEPOINT SET TRANSACTION
DB/DB common 2017. 3. 27. 10:25
[MySQL] Bind Variables

in HeidiSQL SET @AA := 20; SELECT @AA; SET @NUM = 33; SELECT * FROM ( SELECT 11 NUM UNION ALL SELECT 22 NUM UNION ALL SELECT 33 NUM ) A WHERE NUM = @NUM ;
DB/MySQL 2017. 3. 24. 09:55
[MSSQL] Bind Variables

in SQL Server Management Studio DECLARE @AA INT SET @AA = 20 SELECT @AA DECLARE @AA VARCHAR(5) DECLARE @BB VARCHAR(3) SET @AA = '11111' SET @BB = '222' SELECT * FROM ( SELECT '11111' AA, '111' BB UNION ALL SELECT '22222' AA, '222' BB UNION ALL SELECT '11111' AA, '222' BB ) Z WHERE AA = @AA AND BB = @BB ;
DB/MSSQL 2017. 3. 24. 09:51
Prev 1 2 3 4 5 6 7 8 ··· 27 Next