Articles About Database

DBA์™€ ํ•จ๊ป˜ ํ•œ ์ฟผ๋ฆฌํŠœ๋‹ - ๊ทธ๋ฃนํ™”

Database

Create and User accounts

Oracle SQL ๊ณ„์ •์— ๊ด€๋ จ๋œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL DECODE, CASE

Oracle SQL์˜ DECODE, CASE๋ฅผ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL NULL Functions

SQL NULL Functions. Oracle SQL์˜ NULL ํ•จ์ˆ˜์ž…๋‹ˆ๋‹ค.

Database

SQL Date Functions

SQL(Structured Query Language)์˜ Date Functions์„ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL String Functions

SQL String Functions. Oracle SQL์˜ ๋ฌธ์ž ํ•จ์ˆ˜์— ๋Œ€ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL Numeric Functions

SQL Numeric Functions. Oracle SQL์˜ ์ˆซ์ž ํ•จ์ˆ˜์ž…๋‹ˆ๋‹ค.

Database

SQL Data Integrity Constraint Rule

SQL Data Integrity Constraint Rule

Database

SQL JOIN

SQL(Structured Query Language)์˜ JOIN๋ฅผ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL GROUP, HAVING

SQL(Structured Query Language)์˜ ๊ทธ๋ฃนํ•จ์ˆ˜, GROUP BY์ ˆ, HAVING์ ˆ์„ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL ORDER BY

SQL(Structured Query Language)์˜ ORDER BY์ ˆ์„ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL WHERE

SQL(Structured Query Language)์˜ WHERE์ ˆ์„ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

ERROR: ORA-12560: TNS:protocol adapter error

Oracle DB ์ ‘์† ์‹œ protocol adapter error๊ฐ€ ๋ฐœ์ƒํ•  ๊ฒฝ์šฐ ํ•ด๊ฒฐํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database

SQL(Structured Query Language)

SQL(Structured Query Language)์˜ ์ข…๋ฅ˜๋ฅผ ์„ค๋ช…ํ•œ ๊ธ€์ž…๋‹ˆ๋‹ค.

Database