Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    From $11.99/month after trial. Cancel anytime.

    Sql Plsql Oracle
    Sql Plsql Oracle
    Sql Plsql Oracle
    Ebook100 pages38 minutes

    Sql Plsql Oracle

    By Andrew Igla

    ()

    Read preview

    About this ebook

    The book called SQL PLSQL ORACLE here is both a learning and reference book for computer languages SQL, PLSQL and Oracle databases. Practical examples of SQL,PLSQL and Oracle commands are in this book. The book SQL PLSQL ORACLE has everything that is needed in the one book.
    LanguageEnglish
    PublisherXlibris AU
    Release dateJun 1, 2016
    ISBN9781514495575
    Sql Plsql Oracle
    Author

    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

    Related to Sql Plsql Oracle

    Related ebooks

    Computers For You

    View More
    View More

    Related podcast episodes

    Related categories

    Reviews for Sql Plsql Oracle

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      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),

                           

      Enjoying the preview?
      Page 1 of 1