|
|
 |
|
|
Thread Tools | Display Modes |
Nov 2nd, 2006, 11:40 AM
|
#1 |
|
Hobbyist Programmer
Join Date: Mar 2006
Location: Lebanon
Posts: 148
Rep Power: 3
 |
ORACLE Database Setup
Im using windows xp and Oracle Database 10g Release 2 (10.2.0.1.0).
so here is the deal.. all i want to do is install an Oracle Database and simply create one table, say books table. and enter columns ISBN and TITLE then enter a few records into the table... That is all i want to learn... now ive done some research, but im not sure if it is the correct way, or most efficient way of doing it. correct me on this: the easiest way to do what i mentioned above, is to intall the DB, give myself a password and username, run sql plus, and use the CREATE SQL command to create the Books table with its ISBN and PIN columns. then use the INSERT SQL command to enter records.. so using SQL commands is the only way to do this? isnt there some nice and pretty way like the design view in MS ACCESS? Thanks |
|
|
|
Nov 2nd, 2006, 12:47 PM
|
#2 |
|
Programming Guru
 
Join Date: Jul 2004
Location: United States
Posts: 3,467
Rep Power: 8
  |
For Oracle databases, I use Toad from Quest Software as my GUI.
__________________
http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root." |
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| creating user problem ORACLE database | gpreetsingh | Coder's Corner Lounge | 1 | Feb 19th, 2006 3:33 AM |
| Oracle 8i,Is it possible to restrict access to some sensitive Database Objects (User | sham | Other Programming Languages | 1 | Apr 7th, 2005 10:31 PM |
| Using ODBC to connect to a remote database in a C program | bigi | C++ | 1 | Mar 8th, 2005 3:19 PM |
Linear Mode
