[Oracle] Oracle HR Schema 생성
how to create oracle hr schema
Oracle
Oracle Category
[Oracle] SQL 활용 예제
CREATE, ALTER, SELECT, INSERT, UPDATE, DELETE
[Oracle] Troubleshoot for executing sqldeveloper
troubleshooting for executing sqldeveloper
[Oracle] ORA-00984: column not allowed here
ORA-00984: column not allowed here
[Oracle] ORA-28040: 일치하는 인증 프로토콜 없음
ORA-28040 Error
[Oracle] ORA-12505, listener currently does not know of sid given in connect descriptor
ORA-12505, listener currently does not know of sid given in connect descriptor
[Oracle] 집합 연산자 사용법과 VIEW
oracle union, minus, intersect, union all operator
[Oracle] 서브 쿼리
sub-query
[Oracle] Join 활용방법과 예제
inner join, outter join, etc.
[Oracle] Constraints 예시와 사용법 (제약 조건)
oracle constraints examples
[Oracle] 순위 함수
oracle rank functions
[Oracle] 트랜잭션 (Transaction)
commit and rollback
[Oracle] SELECT 구절
select sequence and order by
[Oracle] Operator (산술, 문자열, 비교, 관계, 패턴)
select by using operator
[Oracle] DISTINCT 사용법과 테스트 테이블
oracle distinct keyword
[Oracle] Built-in functions
character, numeric, date, null built-in functions
[Oracle] Data Types
oracle data types
[Oracle] ORA-12514, TNS: listener does not currently know of service requested in connect dscriptor
ORA-12514 Error
[Oracle] Database 공부하자
why do we need to study database?