Sample Text Essay

3002 Words Feb 3rd, 2016 13 Pages
STEPS TO ACCESS ORACLE SERVER AND CERTAIN BASIC QUERIES

(Note: To access the oracle server, sometimes it is required to create a cspc1 account. If the username and password step described below doesn’t work then create a cspc1 account from university website at http://cs.uwindsor.ca/password and use those credentials in the steps described below.)

1. First, download “bitvise ssh client” from the university website on your local machine. This is a secure shell required to connect to the oracle server. A link to download this ssh is as follows: bitvise download.

2. Once this SSH is downloaded, connect to the server using the following credentials:
Hostname: cs.uwindsor.ca
Username: enter your unique username (same as that
…show more content…
SQL> SELECT * FROM INVOICE;

INV_NUMBER CUS_CODE INV_DATE

---------- ---------- ---------

1001 10014 16-JAN-14

1002 10011 16-JAN-14

1003 10012 16-JAN-14

1004 10011 17-JAN-14

1005 10018 17-JAN-14

1006 10014 17-JAN-14

1007 10015 17-JAN-14

1008 10011 17-JAN-14

8 rows selected.

Further all other tables are created.
Now let us check for all the possible queries that can be worked out on these tables.

1. SELECT SYNTAX:
SQL> SELECT P_CODE,P_DESCRIPT,P_PRICE FROM PRODUCT;

OUTPUT:

P_CODE P_DESCRIPT P_PRICE

-------------------- ----------------------------------- ----------

11QER/31 Power painter, 15 psi., 3-nozzle 109.99

13-Q2/P2 7.25-in. pwr. saw blade 14.99

14-Q1/L3 9.00-in. pwr. saw blade

Related Documents