Big Dog

icemountain: To parse or not to parse...

icemountain: To parse or not to parse...

I was also reading the O'Reily document after class and it proved to be really helpful in clarifing a few things about XML, but I have just a few questions #1 What is the difference between a decimal number and a hexadecimal number? It is probably not that important, but I was just curious. Also I'm a little confused about namespaces. We haven't talked about them yet in class, I don't know if they are essencial or not to XML documents. What exactly is their purpose? Anybody got any answers

Foreign Key Error

A funny thing happened while I was working on my project. I accidently created a foregin key realtionship such that the first table contained a foreign key that referenced the second table and the second table contained a foreign key that referenced the first table. This mistake lead to the inability to drop either table because they both depend on each other thus you can't drop one before the other. Is there a way to unspecify a foreign key constraint or is there a way to drop those tables that the mistake was made in? Any ideas are welcome.

Product Command

Is there a instance where this command would be used to analyze a database? It seems like it has no real meaning by pairing certains fields even if they don't occur together in the tables. It just creates a long list of information that would never be used. I was just curious if there was an application for this command that would be useful in database analysis.

SQL Commands

I think Professor Gibson mentioned this in class, but I can't remember. As far as writing SQL commands in jedit, is it better to write all the commands out at once and then run it through Oracle or write each command separately and save it, then run it through Oracle. It would seems like the commands would pile up after awhile in jedit if you did it individually. Just wondering

Editing Code in Pico

I am a little confused as to how to edit commands in pico. I went through my command and found where I made a mistake (CHAR was supposed to be DECIMAL). I went in and changed the command in pico, but I don't know where to go from there. If anyone knows what to do to get the command into Oracle after editing it in pico let me know. It is probably really easy yet I can't figure it out right now. Would it be easier to use jedit?