computers: SQL question

computers blogs about an SQL question

Let me hit each of his questions:

In chapter 2 of "A guide to SQL", I created the Rep table successfully and then I tried to input actual data into the table. When I input the data into the table, do I input it via jEDIT and then view it in Oracle?

I recommend using the method you used to create the rep table. Write the statement in jedit and then run it in Oracle.

Also, if i am supposed to do it in jEDIT do i put the INSERT command in the same file that I created teh table or do i save it as a totally different file? I tried to do it saving it as the same file but had some difficulty getting the data to display.

Personally, I do each one in a separate file. Sometimes, I take a set of insert statements and group them in one file. sqlplus will warn you if there are problems with one of the inserts.