Btu's Profile User Rating: *****

Btu's Photo
Reputation: 34 Craftsman
Group:
Active Members
Active Posts:
244 (0.33 per day)
Joined:
16-May 11
Profile Views:
2,085
Last Active:
User is offline May 21 2013 01:44 PM
Currently:
Offline

Previous Fields

Country:
CA
OS Preference:
Linux
Favorite Browser:
Mozilla
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
0

Latest Visitors

Icon   Btu Ruby is fun

  1. Awards
  2. About Me
  3. Blog

Posts I've Made

  1. In Topic: How to check the actual size in hard disk?

    Posted 17 May 2013

    Check the view: dba_data_files

    select file_name, bytes/1024/1024 "MB" from dba_data_files;

    This is the size of your DB files.

    Hopefully this helps!

  2. In Topic: where to put concat function in this nest?

    Posted 16 May 2013

    Try this:
    select title, 
       '%' || to_char(retail-cost)*100 "Markup %" 
from books;

  3. In Topic: regexp code block

    Posted 16 May 2013

    This is great info, thanks a lot!

  4. In Topic: Method using code blocks

    Posted 16 May 2013

    Thanks for the explanation and example!

  5. In Topic: Index organised tables

    Posted 28 Feb 2013

    After doing some research, and speaking with my prof, I've come to this conclusion about IOT's:

    -An IOT is typically a small table where the index for the PK is the only one needed
    -'Customers' would not be a great choice for this since there are several candidate keys used in queries
    -An IOT is suitable for a lookup/validation table
    -'Organized' is spelled with a 'z' and not an 's' (topic is mis-spelled)

    If anyone would care to add or comment to this, it would be appreciated.

    Thanks

My Information

Member Title:
D.I.C Head
Age:
31 years old
Birthday:
April 1, 1982
Gender:
Location:
B.C., Canada
Years Programming:
3
Programming Languages:
learning C++, VB.NET, Java, SQL, PL/SQL

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://www.bill-tucker.com

Comments

Page 1 of 1
  1. Photo

    trevster344 Icon

    21 Jul 2011 - 09:37
    Thanks for the rep buddy, much appreciated.
Page 1 of 1