목록DB (158)

develog

[Oracle] tnsnames.ora

LOC_DEV_192_SID = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL=TCP)(HOST=192.168.56.101)(PORT=1521) ) ) (CONNECT_DATA =(SID=orcl) ) )LOC_DEV_192_SVNM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL=TCP)(HOST=192.168.56.101)(PORT=1521) ) ) (CONNECT_DATA =(SERVICE_NAME=orcl.localdomain) ) )
DB/Oracle 2016. 9. 13. 10:37
[Oracle] DBMS_JOB, DBMS_SCHEDULER

DBMS_JOBhttp://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_job.htm#BABHCBFD DBMS_SCHEDULERhttps://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sched.htm#CIHHBGGI 25 Moving from DBMS_JOB to DBMS_SCHEDULERhttps://docs.oracle.com/cd/B19306_01/server.102/b14231/jobtosched.htm dbms_job vs. dbms_schedulerhttp://www.dba-oracle.com/t_dbms_job_scheduler.htm 참고http://goalker.tistory.com/99
DB/Oracle 2016. 9. 6. 18:39
[Oracle] hint

USE_NLSELECT /*+ FULL(CU) ORDERED USE_NL(CU PY) */'FROM AAA CU, BBB PYWHERE CU.SEQ = PY.SEQ(+)
DB/Oracle 2016. 7. 13. 11:46
[Oracle] NOLOGGING

CREATE TABLE {TABLE_NM} NOLOGGINGCREATE INDEX {INDEX_NM} NOLOGGING
DB/Oracle 2016. 7. 13. 11:44
[Oracle] SYS_CONNECT_BY_PATH

SELECT SYS_CONNECT_BY_PATH(CODE_NM, '/') PATH, A.* FROM TB_CODE A WHERE USE_YN = 1 START WITH CODE_SEQ = 1 CONNECT BY PRIOR CODE_SEQ = PARENT_CODE_SEQ ORDER SIBLINGS BY SORT_SEQ
DB/Oracle 2016. 6. 20. 10:05
[jdbc] jdbc, driver, connection url

Oracle Driver oracle.jdbc.driver.OracleDriver conn url jdbc:oracle:thin:@{HOST}:{PORT}:{DB_SCHEMA} ※ default port : 1521 MS-SQL Driver com.microsoft.sqlserver.jdbc.SQLServerDriver conn url jdbc:sqlserver://{HOST}:{PORT}; databasename={DB_SCHEMA}; ※ default port : 1433 MySQL Driver com.mysql.jdbc.Driver conn url jdbc:mysql://{HOST}:{PORT}/{DB_SCHEMA} ※ default port : 3306
DB/DB common 2016. 6. 2. 14:10
Prev 1 ··· 5 6 7 8 9 10 11 ··· 27 Next