DBST 651 DBST 651 Session 2 part 1 of 4 McGraw Hill Irwin Copyright 2007 by The McGraw Hill Companies Inc All rights reserved DBST 651 Need workbook for this part of lecture McGraw Hill Irwin Copyright 2007 by The McGraw Hill Companies Inc All rights reserved DBST 651 Discuss Chap 1 of the workbook Go to page 5 v4 v4 means version 4 of workbook Notice that this section deals with tools of the trade and SQL Plus in particular is the tool we want to work with 2 3 Outline Discuss Chap 1 of the workbook For This Project every section of the workbook has a For This Project area means the requirements that is what we are trying to do and what you need to do to exercise the particular aspects of the database technology 2 4 Outline Discuss Chap 1 of the workbook For This Project here we have four items first of all is the test to get into SQL Plus and be able to execute what s called dynamic SQL to do items number 2 3 and 4 2 5 Outline Discuss Chap 1 of the workbook Deliverable is your assignment here you re going to capture some output in a file and put it into your assignment area put a copy of the file that you execute in SQL Plus into your assignment area 2 6 Outline Discuss Chap 1 of the workbook Please note that Database Lab has an area for dynamic SQL an area for executing scripts an area for just getting used to the nova environment including an editor called Pico 2 7 Outline Pico is a full screen editor notice that down on the bottom there are command keys that allow you to traverse it and to save your file the little hat on the top of the letters is the Control key for example X allows you to exit the Pico editor 2 8 Outline For chapter 1 only we are asking you to replicate exactly what is in the workbook so if you go from For this Project to Deliverable to the next section Keep in mind Beware of the By Pass then you will see a sample solution we will like you for this chapter only to replicate the commands that are shown in the workbook 2 9 Outline In the next chapter you will have the chance to do your own creative work Here we are asking you just to get used to the environment and introduce the simple solutions as they are shown The goal is to become comfortable with the environment 2 10 Outline Post 2 deliverables to your assignment area 1 Output captured in a file 2 A copy of a file that executed in sqlplus 2 11 Outline On nova sqlplus Need to be able to get into Oracle sqlplus is our interface If you are having trouble please enter a technical question in the conference area 2 12