Stream: BSCIT(3)
Subject: oracle
DOWNLOAD ORACLE 10G AND INSTALLATION
(FOR THOSE WO HAVE LAPTOP OR PC)
STEP-1: CLICK BELOW TO DOWNLOAD THE SETUP OF ORACLE.
CLICK HERE
STEP-2 :
AFTER CLICK YOU CAN SEE THE BELOW IMAGE.
(MAKE SURE YOU ARE SINED IN YOUR GMAIL ACCOUNT)
THEN CLICK ON DOWNLOAD BUTTON.
IF BELOW SCREEN DISPLAY THEN CLICK ON “DOWNLOAD ANYWAY”
STEP-3:
DOWNLOADING START AFTER CLICKING THE DOWNLOAD BUTTON.
AFTER COMPLETION, OPEN THE SOFTWARE.
DOUBLE CLICK ON SETUP.
GIVE YES
STEP-4:
AFTER GIVE “YES”, START INSTALLING AND GIVE NEXT.
THEY ASK PASSWORD FOR CONNECTING TO ORACLE DATABASE.
IN PASSWORD: TYPE YOUR NAME (FOR E.G. “VIHA”)
STEP -5 :
GIVE FINISH.
NOW YOU CAN SEE THE ORACLE 10G EXPRESS EDITION FOLDER IN START MENU.
CONGRATS!!! YOUR ORACLE IS SUCCESSFULLY INSTALLED.
SET YOU “RUN SQL COMMAND LINE “ AS A ADMINISTRATOR
STEP-1: OPEN PROPERTIES OF “RUN SQL COMMAND LINE”
(FOR WIN 7 )
RIGHT CLICK ON RUN SQL COMMAND LINE AND CLICK ON PROPERTIES.
(FOR WIN 8,10 )
GO TO ORACLE DATABASE 10G EXPRESS EDITION
RIGHT CLICK “ON RUN SQL COMMAND RIGHT”
SELECT “MORE” MENU AND CLICK ON “OPEN FILE LOCATION”.
STEP 2:
NOW YOU WILL THE BELOW IMAGE
NOW RIGHT CLICK ON “RUN SQL COMMAND LINE”
CLICK ON “PROPERTIES”.
STEP-3:
IN PROPERTY WINDOW GO TO COMPATIBILITY MENU.
STEP-4 :
CHECK THE RUN THIS PROGRAM AS AN ADMINISTRATOR.
STEP-5: GIVE OK.
(NOW YOU CAN EDIT OR CHANGE YOUR CODE BY ONLY “ed” COMMAND.)
CREATE TABLE QUERY
SOLUTION:
Create table student(
Id number(5),
Name varchar(25),
Stream varchar(25),
Mobile number(10)
);