Skip to content
/ ORACLE_PL-SQL_LESSONS Public

Within the scope of this course set, after mentioning the use of SQL step by step, advanced PL/SQL programming was started. Advanced PROCEDURE, FUNCTION, TRIGGER, CURSOR, PACKAGE etc. topics are covered.

1 star 1 fork Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

hsynadguzel/ORACLE_PL-SQL_LESSONS

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
.gitattributes
.gitattributes
 
 
CONSTRAINT_HR_MODEL.sql
CONSTRAINT_HR_MODEL.sql
 
 
CREATE_TABLE_HR_MODEL.sql
CREATE_TABLE_HR_MODEL.sql
 
 
CROSS_JOIN.sql
CROSS_JOIN.sql
 
 
CURSOR_EXPLICIT.sql
CURSOR_EXPLICIT.sql
 
 
CURSOR_EXPLICIT_EXP.sql
CURSOR_EXPLICIT_EXP.sql
 
 
CURSOR_EXPLICIT_EXP_2.sql
CURSOR_EXPLICIT_EXP_2.sql
 
 
CURSOR_EXPLICIT_EXP_3.sql
CURSOR_EXPLICIT_EXP_3.sql
 
 
CURSOR_EXPLICIT_EXP_4.sql
CURSOR_EXPLICIT_EXP_4.sql
 
 
CURSOR_EXPLICIT_EXP_5.sql
CURSOR_EXPLICIT_EXP_5.sql
 
 
CURSOR_EXPLICIT_EXP_6.sql
CURSOR_EXPLICIT_EXP_6.sql
 
 
CURSOR_EXPLICIT_EXP_7.sql
CURSOR_EXPLICIT_EXP_7.sql
 
 
CURSOR_EXPLICIT_EXP_8.sql
CURSOR_EXPLICIT_EXP_8.sql
 
 
CURSOR_IMPLICIT.sql
CURSOR_IMPLICIT.sql
 
 
CURSOR_IMPLICIT_EXP.sql
CURSOR_IMPLICIT_EXP.sql
 
 
DATABASE_USER.sql
DATABASE_USER.sql
 
 
DCL_GRANT_AND_REVOKE_STATEMENT.sql
DCL_GRANT_AND_REVOKE_STATEMENT.sql
 
 
DML_INSERT_STATEMENT.sql
DML_INSERT_STATEMENT.sql
 
 
DML_SELECT_HIERARCHICAL_QUERIES.sql
DML_SELECT_HIERARCHICAL_QUERIES.sql
 
 
DML_SELECT_STATEMENT.sql
DML_SELECT_STATEMENT.sql
 
 
DML_UPDATE_AND_DELETE_STATEMENT.sql
DML_UPDATE_AND_DELETE_STATEMENT.sql
 
 
DROP_CONSTRAINT_HR_MODEL.sql
DROP_CONSTRAINT_HR_MODEL.sql
 
 
FULL_JOIN.sql
FULL_JOIN.sql
 
 
FUNCTIONS.sql
FUNCTIONS.sql
 
 
FUNCTION_DROP_DEPARTMENT_NAME.sql
FUNCTION_DROP_DEPARTMENT_NAME.sql
 
 
FUNCTION_FAKTORIYEL_STANDALONE.sql
FUNCTION_FAKTORIYEL_STANDALONE.sql
 
 
FUNCTION_NESTED_EMPLOYEE_LIST.sql
FUNCTION_NESTED_EMPLOYEE_LIST.sql
 
 
FUNCTION_NESTED_EMPLOYEE_LIST_2.sql
FUNCTION_NESTED_EMPLOYEE_LIST_2.sql
 
 
FUNCTION_NESTED_TOPLAM.sql
FUNCTION_NESTED_TOPLAM.sql
 
 
FUNCTION_STANDALONE_DEPARTMENT_NAME.sql
FUNCTION_STANDALONE_DEPARTMENT_NAME.sql
 
 
INNER_JOIN.sql
INNER_JOIN.sql
 
 
LEFT_JOIN.sql
LEFT_JOIN.sql
 
 
NATURAL_JOIN.sql
NATURAL_JOIN.sql
 
 
PROCEDURE_CURSOR_EMP_NAME.sql
PROCEDURE_CURSOR_EMP_NAME.sql
 
 
PROCEDURE_DROP_DEPT-EMP_LIST.sql
PROCEDURE_DROP_DEPT-EMP_LIST.sql
 
 
PROCEDURE_NESTED_EMP_LNAME_UPDATE.sql
PROCEDURE_NESTED_EMP_LNAME_UPDATE.sql
 
 
PROCEDURE_NESTED_EMP_NAME.sql
PROCEDURE_NESTED_EMP_NAME.sql
 
 
PROCEDURE_NESTED_EMP_NAME_LIST.sql
PROCEDURE_NESTED_EMP_NAME_LIST.sql
 
 
PROCEDURE_NESTED_SALARY_UPDATE.sql
PROCEDURE_NESTED_SALARY_UPDATE.sql
 
 
PROCEDURE_NESTED_SALARY_UPDATE_2.sql
PROCEDURE_NESTED_SALARY_UPDATE_2.sql
 
 
PROCEDURE_STANDALONE_DEPT-EMP_LIST.sql
PROCEDURE_STANDALONE_DEPT-EMP_LIST.sql
 
 
PROCEDURE_STANDALONE_STORED_HW.sql
PROCEDURE_STANDALONE_STORED_HW.sql
 
 
PROCEDURE_STORED_EXP.sql
PROCEDURE_STORED_EXP.sql
 
 
README.md
README.md
 
 
RIGHT_JOIN.sql
RIGHT_JOIN.sql
 
 
ROLES.sql
ROLES.sql
 
 
SELF_JOIN.sql
SELF_JOIN.sql
 
 
SET_OPERATORS.sql
SET_OPERATORS.sql
 
 
SYSADMIN.sql
SYSADMIN.sql
 
 
TRIGGER.sql
TRIGGER.sql
 
 
TRIGGER_EXP_2.sql
TRIGGER_EXP_2.sql
 
 
TRIGGER_EXP_3.sql
TRIGGER_EXP_3.sql
 
 
human_resources_diagram.pdf
human_resources_diagram.pdf
 
 

Repository files navigation

ORACLE_PL-SQL_LESSONS

From scratch to advanced Oracle SQL. Within the scope of this course set, after mentioning the use of SQL step by step, advanced PL/SQL programming was started. Advanced PROCEDURE, FUNCTION, TRIGGER, CURSOR, PACKAGE etc. topics are covered. (Sıfırdan ileri seviye Oracle SQL. Bu ders seti kapsamında adım adım SQL kullanımına değinildikten sonra ileri seviye PL/SQL programlamaya geçilmiştir. İleri seviye PROCEDURE, FUNCTION, TRIGGER, CURSOR, PACKAGE vb. konular ele alınmıştır.)

  • CREATE USER
  • CREATE TABLE
  • CREATE TYPE
  • INSERT INTO
  • CONSTRAINT
  • JOINS
  • DCL
  • DML
  • TCL
  • DDL
  • ROLES
  • SYSTEM FUNCTION
  • CURSOR
  • PROCEDURE
  • FUNCTION
  • TRIGGER
  • PACKAGE

HR DIAGRAM

hr_oracle

About

Within the scope of this course set, after mentioning the use of SQL step by step, advanced PL/SQL programming was started. Advanced PROCEDURE, FUNCTION, TRIGGER, CURSOR, PACKAGE etc. topics are covered.

Topics

sql oracle oracle-db oracle-database

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

 
 
 

Languages