Notes
Notes - notes.io |
(c) 2019 Microsoft Corporation. All rights reserved.
C:Userslab>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 17 16:37:08 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: it381h
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> @D:Colz.sql
Table created.
Table created.
Table created.
Table created.
Table created.
Table created.
Table created.
Table created.
Table created.
Table created.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Table altered.
Table altered.
SQL> @D:Emp.sql
Drop table DEPT
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
Drop table DEPENDENT
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
Table altered.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
Drop Table QUALIFICATION
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
DROP TABLE EMPLOYEE
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
Drop table EMPLEVEL
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
Drop table POSITION
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
Table altered.
Table altered.
Table altered.
Table altered.
SQL> select last ||'.'|| first name ,final from student,registration where student.studentid = registration.studentid and final='F';
NAME F
------------------------------- -
Diaz.Jose F
SQL> select last ||'.'|| first name from student;
NAME
-------------------------------
Diaz.Jose
Tyler.Mickey
Patel.Rajesh
Rickles.Deborah
Lee.Brian
Khan.Amir
6 rows selected.
SQL> select last ||'.'|| first name and Majorid from student;
select last ||'.'|| first name and Majorid from student
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select last ||'.'|| first name , Majorid from student;
NAME MAJORID
------------------------------- ----------
Diaz.Jose 100
Tyler.Mickey 500
Patel.Rajesh 400
Rickles.Deborah 500
Lee.Brian 600
Khan.Amir 200
6 rows selected.
SQL> select s.first,f.name as "Advisor Name",1.roomno||' '||1.building||' '||r.roomdesc as "Location" from student s,faculty f,location l, room r where f.facultyid=s.facultyid and f.roomid=1.roomid and 1.roomtype=r.roomtype;
select s.first,f.name as "Advisor Name",1.roomno||' '||1.building||' '||r.roomdesc as "Location" from student s,faculty f,location l, room r where f.facultyid=s.facultyid and f.roomid=1.roomid and 1.roomtype=r.roomtype
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select s.first,f.name as "Advisor Name",1.roomno||' '||1.building||' '||r.roomdesc as "Location" from student s,faculty f,location l, room r where f.facultyid=s.facultyid and f.roomid=1.roomid and 1.roomtype=r.roomtype;
select s.first,f.name as "Advisor Name",1.roomno||' '||1.building||' '||r.roomdesc as "Location" from student s,faculty f,location l, room r where f.facultyid=s.facultyid and f.roomid=1.roomid and 1.roomtype=r.roomtype
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select Title,Prerqe from course;
select Title,Prerqe from course
*
ERROR at line 1:
ORA-00904: "PRERQE": invalid identifier
SQL> select Title,Prereq from course;
TITLE PREREQ
-------------------- ------
Basic English
English Literature EN100
Database Systems
Systems Analysis CIS253
College Algebra
Accounting
6 rows selected.
SQL> select cs.section as "section",f.Name as "Faculty" from crssection cs,faculty f where f.facultyid=cs.facultyid and cs.termid=(select termid . from term where termdesc = 'Spring 2003');
select cs.section as "section",f.Name as "Faculty" from crssection cs,faculty f where f.facultyid=cs.facultyid and cs.termid=(select termid . from term where termdesc = 'Spring 2003')
*
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification
SQL> select Fname,Deptname from employee,dept where employee.deptid=dept.deptid;
FNAME DEPTNAME
---------- ---------------
John Finance
Larry Marketing
Sandi Finance
Alex InfoSys
Derek InfoSys
Jinku Sales
Stanley Sales
Sunny Finance
8 rows selected.
SQL> select e1.Fname from employee e1,employee e2 where e1.Employeeid=e2.supervisor and e2.employeeid=433;
FNAME
----------
Derek
SQL>
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
