group by TABLESPACE_NAME
sum(BYTES) BYTES ,
group by TABLESPACE_NAME
order by ((a.BYTES-b.BYTES)/a.BYTES) desc;
Produces something like this:
Every now & then I’m forced to deal with databases in Access, the worst case of this is when the database started life in something else, ‘cos that when Dates usually get really screwy.
I recently had one with dates stored as 3 seperate fileds, I know I should have transformed the data, but I didn’t, so I came up witha few queries that tried to munge the data into something usable, my first attempt was this:
But then I found a better way:
Where DateFromDMY is a VB function, something akin to:
Public Function DateFromDMY(a_Day As Integer, a_Month As Integer, a_Year As Integer) As Date
If (a_Day = 0) Then
a_Day = 1
If (a_Month = 0) Then
a_Month = 1
If (a_Month > 12) Then
a_Month = 12
DateFromDMY = CDate(CStr(a_Day) + “/” + CStr(a_Month) + “/” + CStr(a_Year))
Now that’s a crude function, but you get the idea, you can fix up data easily.
Thank you Martin Green for his pointers here.
If you use firefox, you need Tab Mix Plus. The site is here, and you can install it from here. I used to use Session Saver .2 & some japanese fellow’s Tabbed Browsing Extensions, but this does it all, it’s much slicker & I’m very happy 🙂
Update: 14th July 2006
I’m considering adding Bookmarks Synchronizer 3 to this list..
I’ve just discovered that my auntie has a blog! It’s part of the website for their B&B, Carno House, how cool is that!
Great work Auntie Hilda!
It’s just one of those tools you can’t live with out.
Here is a list of some of the most frequently used SQL*Plus commands:
• ACCEPT – Get input from the user
• DEFINE – Declare a variable (short: DEF)
• DESCRIBE – Lists the attributes of tables and other objects (short: DESC)
• EDIT – Places you in an editor so you can edit a SQL command (short: ED)
• EXIT or QUIT – Disconnect from the database and terminate SQL*Plus
• GET – Retrieves a SQL file and places it into the SQL buffer
• HOST – Issue an operating system command (short: !)
• LIST – Displays the last command executed/ command in the SQL buffer (short: L)
• PROMPT – Display a text string on the screen. Eg prompt Hello World!!!
• RUN – List and Run the command stored in the SQL buffer (short: /)
• SAVE – Saves command in the SQL buffer to a file. Eg “save x” will create a script file called x.sql
• SET – Modify the SQL*Plus environment eg. SET PAGESIZE 23
• SHOW – Show environment settings (short: SHO). Eg SHOW ALL, SHO PAGESIZE etc.
• SPOOL – Send output to a file. Eg “spool x” will save STDOUT to a file called x.lst
• START – Run a SQL script file (short: @)