computers

sql question

When creating tables in sql, do you have to designate foreign keys somehow or do you just put them in as regular attributes?

SSH or jEDIT

After talking to some fellow classmates, there was some uncertainty whether you can type your query directly into Oracle or if you have to do it in jEDIT. I was experimenting in class and you can type it in Oracle but it is very inefficient. If you have mistakes in your command you have to retype the entire command - at least that is what I have found. In jEDIT, you can easily go back to your file and revise and change your command. Although it gets some what redundant saving every little query, it pays off in the long run. Just wanted to let people know, since I know some of us were wondering.

SQL question

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? 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.

A test post

This is my first post... im so excited for BIT 320. Taking this class is like riding on the millenium force at cedar point. woohoo