Skip to content
Tech Trainings
Learn.Code.Share
  • Home
  • Infrastructure Access
  • Online Resources
  • Blog
  • Contact Us

Category: Database

How to create file in Oracle Database Using UTL_FILE Approach

February 1, 2025 admin Leave a comment

Continue Reading →

Posted in: Database

How to get previous year and future year value using EXTRACT and CONNECT BY LEVEL in Oracle Database

January 25, 2025 admin Leave a comment

Continue Reading →

Posted in: Database

DEPT and EMP Table Scripts Oracle Database

October 13, 2021 admin Leave a comment

create table dept(deptno number(2,0),dname varchar2(14),loc varchar2(13),constraint pk_dept primary key (deptno)) ; create table emp(empno number(4,0),ename varchar2(10),job varchar2(9),mgr number(4,0),hiredate date,sal number(7,2),comm…

Continue Reading →

Posted in: Database

Oracle Database PLSQL Triggers

December 11, 2020 admin Leave a comment

What is a Trigger Is a PL/SQL block or PL/SQL procedure associated with a table, view, schema, or the database…

Continue Reading →

Posted in: Database

Oracle Database Course – WHERE and ORDER BY Clause

October 25, 2020 admin Leave a comment

Continue Reading →

Posted in: Database

SQL For Non Technical

November 5, 2019 admin Leave a comment

Tough job for a functional or business analyst is to understand the nuance of Database. It is not that much…

Continue Reading →

Posted in: Database
Copyright © 2026 Tech Trainings — Ascension WordPress theme by GoDaddy