CSSE3004 individual component: Part 1
In category General on 10 Sep 2005 @ 01:44 pm
Sitting in the labs doing assignments and I instantly decide it's time to update my site (I wonder why?).
At the moment I'm having some issues with getting all data out of an Oracle database without knowing the names of the tabels and such. So I start with a basic:
Which returns me a whole heap of crap!
It appears our database is currently in a state of emergency. Now I wonder what all the tables with a table type of "sequence" are. And why there are 8 of them. Time to ask the guys what's going on. In the mean time I need to work out how to get the column names from each of the tables so I can XML the whole lot with the column names as tags.
Suggestions?
SQL-ly Maz
At the moment I'm having some issues with getting all data out of an Oracle database without knowing the names of the tabels and such. So I start with a basic:
SELECT * FROM cat;
Which returns me a whole heap of crap!
It appears our database is currently in a state of emergency. Now I wonder what all the tables with a table type of "sequence" are. And why there are 8 of them. Time to ask the guys what's going on. In the mean time I need to work out how to get the column names from each of the tables so I can XML the whole lot with the column names as tags.
Suggestions?
SQL-ly Maz
The question was more along the lines of.. what the hell is GST_SEQ? Why?
Comment by Maz on 11 Sep 2005 @ 12:06 am
Comment by Maz on 11 Sep 2005 @ 12:06 am
You have to pay 11% to make the sequence go away! Or 1/11, I can never remember.
Comment by on 11 Sep 2005 @ 12:15 am
Comment by on 11 Sep 2005 @ 12:15 am
Comment by thei on 10 Sep 2005 @ 07:41 pm
http://the-i.org/