How to Create SCOTT Schema and default tables in Oracle Database 11g

-

How to Create SCOTT Schema and default tables in Oracle Database 11g 

Written By Arshman Saleem
                             

                                   Watch this Complete Tutorial for Create Scott Schema

 (If Any Query about this article then you can contact  Arshman)

If there is no Oracle default schema is available after the installation of Oracle 11g database in windows. Then how to create the Scott Schema and the default tables like Emp, Dept, bonus in database. Here is the easy step by step tutorial to create in your database.

• Open the SQL Plus/SQL Command Prompt in your system.
• Login as username : sys as sysdba and the password which is given at the time of installation.
• After connected to Oracle database you need to create the Scot Schema.
• Run this Script.

Create User Scott Identified By tiger;

Scott the user

Tiger is the password.

Grant all access to user Scott, run this Script.

Grant all Privileges to Scott;

Download the Oracle Default Table File.

Extract the download file in your system.

Then Connect to Scott user as

Connect  Scott

Password : Tiger

Then Type this your SQL Command Prompt.

@(Extract file path)\Oracle.Sql;

For Example:

@C:\Users\ABC\oracle\oracle.sql;

Now you done all the steps completely and you can work with Scott Schema and all the default tables.

For More Usefull Post's...!!
Follow me On Facebook       :  Arshman Saleem

Subscribe me On Facebook :  Computer Programming Assignment's

Follow me On Twitter            :  @Arxhman

Read More

GPA Calculator For Bahria University Students (All Department)

A Student Grade Point Average(GPA) is Calculated By Dividing the Total Numbers of Grade Points Earned by the Total number of Credit hours attempt. GPA is calculated on a four point Scale.
Want to Calculate your University Exam Grade?? Our Easy to Use University GPA Calculator will help You Calculate your GPA in Just Minutes.

    Click Here 
       Download


















**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//

Read More

GPA Calculator for BUKC Students (CS 3rd Semester)

A Student Grade Point Average(GPA) is Calculated By Dividing the Total Numbers of Grade Points Earned by the Total number of Credit hours attempt. GPA is calculated on a four point Scale.
Want to Calculate your University Exam Grade?? Our Easy to Use University GPA Calculator will help You Calculate your GPA in Just Minutes.

Click here to Download




**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**

Read More

Computer Shop Management System Project C++

Computer Shop Management System



In this Computer Shop Management System all the requirement has been added which makes the computer shopkeeper to perform all their task by their own such as knowing details of daily transaction, preparing balance sheet and knowing stock details of each product under their shop by just one click.

Existing computer shop management system only having the potential to perform processing task for limited section. In this system shopkeeper have to enter customers report every time when ever they visited their group. There was no any medium to find the customers record using any unique key or customers id. If the record of any items is to be revised, then search operation is performed to find the item and make updation. The present system was not able to make balance sheet, only the daily transaction was saved in the file, which was sanded to the charted accountant office to prepare balance sheet which is again not secure with respect to the customer details.

Read More

Hotel Management System Project C++

Hotel Management System


This new Hotel Management System has been developed to meet all the processing requirements which are needed within the hotel industry. This system will allow the Hotel Reception department to manage all the records of their customers and their payment in easy manner. The Person who will use this system will able to get all detail on how to use the instruction in office mode, so no need to take special training before using the system. All proper keywords has been used to define each function of this new system.

--------------------------------
For Project : Click Here
--------------------------------

Read More

Library Management System Project C++

Library Management System

This C++ Menu driven Programs on Library Management System has Books and Student Class with data members like book, no, Book Name and author Name. Books Records is stored in a Binary file. A Student can issue book and deposit it within 15 days. Student is allowed issue only one book. Student records are stored in binary file. Administrator can add, modify or delete record.
In this Project we have not used graphics to keep program simple.

--------------------------------
For Project : Click Here
--------------------------------

Read More

Bank Management System Project C++

Bank Management System



This C++ program on Bank Management System has account class with data members like account number, Name, Deposit, With Draw Amount and type of account. Customer data is stored in a binary file. A Customer can deposit and with draw in his account. User can create, modify and delete account.
In this System we have not use Graphics to keep program Simple.

--------------------------------
For Project : Click Here
--------------------------------

Read More