Cis/336 Ilab 7 of 7 - Sql Course Essay

1101 Words Nov 24th, 2014 5 Pages
CRAM Exclusive
Essay Sample: Page 2
Remember in using a Spool Session, you must type "SPOOL OFF" at the SQL> PROMPT after your Script stops spooling to capture all of your data!



Lab Do's and Don't's

Do Not include the LEEBOOKS.SQL as part of your lab script.

Do use Notepad to write your query script file.



Do Not write your queries in Word.

Do test each query before moving on to the next.



Do Not include extra queries for a problem unless the problem explicitly asks for more than one query.

Do test your queries before creating your final output file.



Do Not turn in a scrip file that has queries with errors.

Do number each query using either --1 or REM 1 comment notation.



Do Not start your query on the same line as the comment.

Do remember to check your final output and script file for accuracy.



Do Not turn in your lab without first checking your output file to verify that it is correct.





Things to keep in mind:



If you are not sure of the table names in your user schema, you can use the following select statement to list them.



SELECT * FROM TAB;



If you want to know the name of the columns in a particular table, you can use the following command to list them.



DESC



Making a script file containing a series of describe statements for each table and then spooling the output will give you a listing of all the tables with column names.



Be sure to review and verify your final output when you are finished. Do Not assume anything.
CRAM Exclusive
House52336Bear

Related Documents

  • Essay on Cis/336 Ilab 3 of 7 - Sql Course

    -------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-3-of-7/ --------------------------------------------------- CIS/336 iLab 3 of 7 - SQL Course ________________________________________ Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in Oracle itself. The editor interface to the Oracle server is SQL*Plus, and by now you have received your logon ID and password and should have at least made sure

    Words: 1456 - Pages: 6
  • Cis/336 Ilab 5 of 7 - Sql Course Essay example

    HELPIDO.COM ------------------------------------------------ Follow this link to get the tutorial www.helpido.com/cis336ilab5-of-7/ ------------------------------------------------ CIS/336 iLab 5 of 7 - SQL Course ________________________________________ Lab 5 of 7: Retreiving data from Multiple Tables (28 points) L A B O V E R V I E W Scenario/Summary Lab 5 deals with writing queries using multiple tables as covered in the reading and lecture material this week. In some

    Words: 1579 - Pages: 7
  • Cis/336 Ilab 3 of 7 - Sql Course Essay examples

    -------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-3-of-7/ --------------------------------------------------- CIS/336 iLab 3 of 7 - SQL Course ________________________________________ Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in Oracle itself. The editor interface to the Oracle server is SQL*Plus, and by now you have received your logon ID and password and should have at least made sure

    Words: 1462 - Pages: 6
  • Cis/336 Ilab 2 of 7 - Sql Course Essay example

    HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary Lab two introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be given a business scenario for a company named Clapham Specialty

    Words: 1462 - Pages: 6
  • Cis336,Cis/336,Cis 336,Cis/336 Ilab 3 of 7,Cis336 Ilab 3 of 7,Cis 336 Ilab 3 of 7

    TO GET THE TUTORIAL ---------------------------------------------------- http://helpido.com/category/cis-336/ ---------------------------------------------------- cis 336 CIS/336 iLab 3 of 7 – SQL Course Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in Oracle itself. The editor interface to the Oracle server is SQL*Plus, and by now you have received your logon ID and password and should have at least made sure you can connect

    Words: 1457 - Pages: 6
  • Essay on Cis336 Cis 336 Cis/336 Ilab 3 of 7

    -------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-3-of-7/ --------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 3 of 7 - SQL Course ________________________________________ Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in Oracle itself. The editor interface to the Oracle server is SQL*Plus, and by now you have received your logon ID and password and should have at least made

    Words: 1455 - Pages: 6
  • Cis 336 Cis336 Cis/336 Ilab 1 of 7 Essay

    HELPIDO.COM -------------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-1-of-7/ -------------------------------------------------------- CIS 336 CIS336 CIS/336 iLab 1 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD)

    Words: 944 - Pages: 4
  • Cis 407 a Ilab 7 of 7 Essay

    FOLLOW THE LINK TO GET THE TUTORIAL HTTP://HELPIDO.COM/CIS-407-ILAB-7-OF-7/#5 ---------------------------------------------------------------- CIS 407 A ILAB 7 OF 7 ________________________________________ Scenario/Summary In this lab, we will incorporate error handling into the login process so that a notice of each invalid login is automatically e-mailed to the technical support staff. Instruction to Week 7 iLab: Error Notification via E-MailClick on the link above to view

    Words: 1751 - Pages: 7
  • Cis 339 Ilab 7 of 7 Essay example

    HELPIDO.COM ---------------------------------------------------- Follow this link to get the tutorial http://helpido.com/cis-339-ilab-7-of-7/ ---------------------------------------------------- CIS/339 iLab 7 of 7 ________________________________________ Your demonstrations of how to create both method contract and the method specification for the GetCourseByCourseID() method of the CourseList class were very well received by your team members. They then asked you for one final

    Words: 717 - Pages: 3
  • Cis 170 Ilab 7 of 7 Essay example

    HELPIDO.COM ------------------------------------------------- Follow this link to get the tutorial http://helpido.com/cis-170-ilab-7-of-7-bluebird-airlines-needs-a-program-to-assign-boarding-passes-on-its/ -------------------------------------------------- CIS 170 iLab 7 of 7 Step 1: Requirements - Airline Reservation System Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity of 20. They want to use an alphanumeric seat number

    Words: 1582 - Pages: 7