CS3340:  Intro OOP and Design

SETUP toad for oracle

1) download Oracle instant client to your machine you have toad on

 

2) setup connnection

HERE you see where I have specified the CLIENT

 

To create a new table

1) Database->Create->Table

2) Fill out the Name of table and add columns

here you see the results... How to bring up Table and add entries

 

1) Database->Schema

2) enter in data

3)Make sure your data is committed or won't actually be saved

 

How to execute SQL queries inside TOAD (useful to test what your code might see as a result of a query)

1) type in SQL query in query window
2) hit Run button
3) View results

 

 

 

FOR MAC: the GUI will be similar but, different go to TOAD website for details on how to use...here are some tips in an image

 

© Lynne Grewe