/ORACLE_PL-SQL_LESSONS

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.

Primary LanguagePLSQL

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