목록DB/DB common (6)

develog

[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
[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
[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
ROWNUM, TOP, LIMIT

--OracleSELECT *FROM AATESTWHERE ROWNUM
DB/DB common 2015. 10. 22. 10:44
Configuring Connection Pooling in Tomcat

Configuring Connection Pooling in Tomcathttp://www.javaexperience.com/connection-pooling-in-tomcat/...
DB/DB common 2013. 3. 7. 13:10
rownum, top, limit

--OracleSELECT *FROM TABLE_NMWHERE ROWNUM
DB/DB common 2013. 3. 6. 11:17
Prev 1 Next