SQL statement

• spycampers

  27 Apr 08, 13:39

  hi all..

  anyone good at SQL statement??

   

  if i want to view the space in bytes for a user..

  how should i write the

  Select statement?

• GIB

  27 Apr 08, 19:27

  What do you mean space for a user? You mean like disk quota? Or are you talking about user data that is stored in a table?

• Shotgun

  27 Apr 08, 19:40

  If you find yourself having to write very cheem SQL statements, it probably means you need to re-design your db.

  After working for a while, I discovered more db designs don't go beyond 1NF.  If everything can be squeezed into 1 table, just squeeze it.  Just try not to do a Select * when retrieving records.

• Xcert

  28 Apr 08, 16:57

  Originally posted by spycampers:

  hi all..

  anyone good at SQL statement??

   

  if i want to view the space in bytes for a user..

  how should i write the

  Select statement?

  Assuming U want to see the availble HDD space...I dont see why U need SQL statements unless that information has already been entered into a database.

• spycampers

  28 Apr 08, 17:57

   SELECT  SUM(BLOCKS) TOTBLOCKS,

   SUM(BYTES) TOTBYTES

   

   FROM SYS.DBA_EXTENTS

   WHERE OWNER = UPPER('&ONAME')

   

   

   

  actually i want to run something like this..

  but fail..

  how come??

   

• GIB

  28 Apr 08, 18:49

  http://www.orafaq.com/scripts/sql/tabinfo.txt

  Not sure if it will help. I am not an Oracle person.

• spycampers

  29 Apr 08, 09:44

  thank. get wat i need.

  :-)

   

• Agenda

  29 Apr 08, 10:12

  I hate database