Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Pro*C

( Duration: 5 Days )

Embedded SQL is a method of combining the computing power of a high-level language like C/C++ and the database manipulation capabilities of SQL. It allows you to execute any SQL statement from an application program. Oracle's embedded SQL environment is called Pro*C.

The Pro*C training course covers the concepts of Host/Bind Variable declaration, Static SQL and Dynamic SQL, Using ORACA, Performance issues, Embedded SQL syntax differences, Using PL/SQL Stored Procedures and so on

COURSE AGENDA

1

Overview

2

Pro*C Syntax

  • SQL
  • Preprocessor Directives
  • Statement Labels
3

Host Variables

  • Basics
  • Pointers
  • Structures
  • Arrays
  • Indicator Variables
  • Datatype Equivalencing
4

Dynamic SQL

5

Transactions

6

Error Handling

  • SQLCA
  • WHENEVER Statement
7

Demo Programs

8

C++ Users

9

List of Embedded SQL Statements Supported by Pro*C

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X