As per the culture of Pillai HOC College of Engineering, Department of Computer Engineering organizes various Technical Workshops for aspirants assembling with various interests in the field with a very high competitive spirit to participant and with the strong determination to include their achievements & accomplishments to their resumes. For the preceding academic year 2018-19, we have organized a Workshop on “PL/SQL” on 9th March, 2019. Workshop on “PL/SQL” was conducted by Mr. Devendra Terse. Ms. Ekta Ukey, CSI Coordinator has introduced the trainer that he has 6 years of experience in the areas of Client Interfacing, Development, Reference Data Management and Investment Banking Solutions, automation, Oracle Flexcube Application. He worked as Associate Consultant at Capgemini Pvt. Ltd., Mumbai. Dr. Ashok Kanthe welcomed the guest with the bouquet.
Mr. Devendra Terse, Consultant, Oracle Financial Services Software, Mumbai
Basically PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency.
The workshop covered some following basic and advance topic based on PL/SQL:
- Basic Knowledge of SQL
- Types of SQL commands – Data Definition Language (DDL),
Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Statement (TCS), Session Control Statements (SCS)
- Oracle Joins, Oracle Constraints, Indexes, View
- Basic Knowledge of PL/SQL
- Data Types of PL/SQL – Scalar : Numeric, Character, Boolean, Datetime
Large Object (LOB) : BFILE, BLOB, CLOB, NCLOB
- Variable, Loops, Arrays, Procedure, Functions, Exceptions, Cursor, Trigger, Package