plsql online training with real time experts - PowerPoint PPT Presentation

About This Presentation
Title:

plsql online training with real time experts

Description:

Ithubonlinetraining is provides the plsql online training This class supplies an introduction. Describe the building blocks of PL/SQL and its own surroundings Clarify the advantages of the essential elements of PL/SQL online training arrangements Clarify the advantages of programs over standalone procedures and functions Create numerous kinds of use procedures and causes CreateThis class presents the common characteristics shared by the package of tools in Oracle Developer/2000.This class investigates the development of programs using Oracle Reports and Oracle Forms. contact: india:8121311133 usa:+1-347-606-2716 contact@ithubonlinetraining.com – PowerPoint PPT presentation

Number of Views:30
Slides: 11
Provided by: williamscreater

less

Transcript and Presenter's Notes

Title: plsql online training with real time experts


1
PL\SQL ONLINE
TRAINING
2
Infrastructure setup
  • Installation of Virtual workstation
  • Installation of Operating system
  • Assigning static ip to Ethernet
  • Login to the OS
  • Installing Virtual tools
  • Sharing of Folders from host OS to virtual OS
  • Cloning of OS in virtual workstation
  • Start and Shut of OS

3
Installing ORACLE And Database creation
  • Installing Oracle binary
  • Database creation

4
Connecting to Database
  • SQLPLUS toolVerify database nameVerify database
    statusVerify control file locationVerify data
    files locationVerify redo log files
    locationShut databaseStartup database

5
PLSQL FRAME WORK
6
Functions
  • Single row functionGroup functionsNumeric
    functionsString functionsDate
    functionsMiscellaneous functionsConversion
    functions

7
Constraints
  • Domain integrity constraintsNot
    nullCheckEntity integrity constraintsUniquePri
    mary keyReferential integrity constraintsForeign
    key

8
Case and default
  • Abstract data types
  • Object view and methods
  • Varrays and nested tables
  • Flashback query
  • External tables
  • Ref deref value

9
(No Transcript)
10
contact india8121311133 usa1-347-606-2716 cont
act_at_ithubonlinetraining.com http//www.ithubonlin
etraining.com/oracle-sql-online-training/
Write a Comment
User Comments (0)
About PowerShow.com