Programming Forums - View Single Post

hbe02 · Nov 2nd, 2006, 12:40 PM

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:40 PM	#1
hbe02 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