Sql Plsql Oracle
By Andrew Igla
()
About this ebook
Andrew Igla
The author Andrew Igla is an electronics engineer and an electronic communications engineer expert in Information Technology regarding computer languages SQL, PLSQL and general Oracle issues.
Read more from Andrew Igla
Luftvafer Rating: 0 out of 5 stars0 ratings
Related to Sql Plsql Oracle
Related ebooks
Basic DBA Query v.1: Oracle Database Rating: 5 out of 5 stars5/5Pro Oracle SQL Development: Best Practices for Writing Advanced Queries Rating: 0 out of 5 stars0 ratingsOracle OBIEE Interview Q & A Rating: 3 out of 5 stars3/5Oracle SOA BPEL Process Manager 11gR1 A Hands-on Tutorial Rating: 5 out of 5 stars5/5Oracle E Business Suite A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsORACLE 12C Complete Self-Assessment Guide Rating: 0 out of 5 stars0 ratingsIBM InfoSphere DataStage A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsQuerying with SQL T-SQL for Microsoft SQL Server Rating: 3 out of 5 stars3/5100+ SQL Queries Jet SQL for Microsoft Office Access Rating: 5 out of 5 stars5/5SQL for Microsoft Office Access Rating: 3 out of 5 stars3/5Advanced SAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratings100+ SQL Queries T-SQL for Microsoft SQL Server Rating: 4 out of 5 stars4/5SQL Cookbook Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 1 Rating: 5 out of 5 stars5/5Ms Access 2007: Step by Step Rating: 5 out of 5 stars5/5Oracle SQL and PL/SQL Rating: 5 out of 5 stars5/5SQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5Blazor and API Example: Classroom Quiz Application Rating: 0 out of 5 stars0 ratingsQuerying with SQL JET SQL for Microsoft Office Access Rating: 0 out of 5 stars0 ratingsMicrosoft Excel Functions Vol 1: 1 Rating: 1 out of 5 stars1/5Excel Functions for the Daily User Rating: 0 out of 5 stars0 ratingsDB2 11.1 for LUW: SQL Basic Training for Application Developers Rating: 0 out of 5 stars0 ratingsJava Programming Tutorial With Screen Shots & Many Code Example Rating: 0 out of 5 stars0 ratingsDB2 11 for z/OS: SQL Basic Training for Application Developers Rating: 4 out of 5 stars4/5Introduction to PHP, Part 2, Second Edition Rating: 0 out of 5 stars0 ratingsSQL Queries: 200+ Queries to Challenge you. Rating: 5 out of 5 stars5/5Relational Database Systems Rating: 0 out of 5 stars0 ratingsMATLAB for Beginners: A Gentle Approach Rating: 0 out of 5 stars0 ratingsLearn Programming Using C# Rating: 0 out of 5 stars0 ratingsMATLAB for Beginners: A Gentle Approach - Revised Edition Rating: 0 out of 5 stars0 ratings
Computers For You
The Invisible Rainbow: A History of Electricity and Life Rating: 5 out of 5 stars5/5Procreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 0 out of 5 stars0 ratingsSlenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5The Innovators: How a Group of Hackers, Geniuses, and Geeks Created the Digital Revolution Rating: 4 out of 5 stars4/5Elon Musk Rating: 4 out of 5 stars4/5Standard Deviations: Flawed Assumptions, Tortured Data, and Other Ways to Lie with Statistics Rating: 4 out of 5 stars4/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsMastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5Alan Turing: The Enigma: The Book That Inspired the Film The Imitation Game - Updated Edition Rating: 4 out of 5 stars4/5The Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5The Complete Powershell Training for Beginners Rating: 0 out of 5 stars0 ratings101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 4 out of 5 stars4/5The Hacker Crackdown: Law and Disorder on the Electronic Frontier Rating: 4 out of 5 stars4/5Uncanny Valley: A Memoir Rating: 4 out of 5 stars4/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5The Huffington Post Complete Guide to Blogging Rating: 3 out of 5 stars3/5Going Text: Mastering the Command Line Rating: 4 out of 5 stars4/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5
Reviews for Sql Plsql Oracle
0 ratings0 reviews
Book preview
Sql Plsql Oracle - Andrew Igla
Copyright © 2016 by Andrew Igla.
All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage and retrieval system, without permission in writing from the copyright owner.
Any people depicted in stock imagery provided by Thinkstock are models, and such images are being used for illustrative purposes only.
Certain stock imagery © Thinkstock.
Rev. date: 05/12/2016
Xlibris
1-800-455-039
www.Xlibris.com.au
740893
CONTENTS
Chapter 1: SQL
Chapter 2: PLSQL
Chapter 3: Oracle
This is a book about sql, plsql and Oracle. The first chapter is about SQL. The second chapter is about PLSQL and the third chapter is about Oracle.
Chapter 1
SQL
Let us say there is a table worker. To allow select, insert, update on table worker for user Andrew note the following.
SQL command.
Grant select, update, insert on worker to Andrew;
Let us say we wish to create a role in oracle. Note the following.
SQL command.
Create role Andrew_role;
Let us say we wish Andrew_role to select, update, insert to table worker. Note the following.
SQL command.
Grant select, update, insert on worker to Andrew_role;
Let us say we wish user Michael and Andrew to have the same privileges as Andrew_role on table worker. Note the following.
SQL command.
Grant Andrew_role to Andrew;
Grant Andrew_role to Michael;
Let us say we wish user Andrew to be connected to the database. Note the following.
SQL command.
Connect Andrew/newpassword;
Let us say we wish to create a sequence being a number getting bigger by one. Note the following.
SQL command.
Create sequence worker_ID
start with 100
increment by 1;
Let us say we wish to find the current value of the sequence
worker_ID. Note the following.
SQL command.
Select worker_ID.currval
from dual;
Let us say we wish to find next value of sequence worker_ID. Note the following.
SQL command.
Select worker_ID.nextval
from dual;
Let us say we wish to create a table school. Note the following.
SQL command.
Create table school (
schoolname varchar2(25),
teachername varchar2(25),
yearnumber number,
hiredate date);
Let us say we wish to create table address. Note the following.
SQL command.
Create table address(
sirname varchar2(25),
firstname varchar2(25),