Re: Need a SQL
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 9 Jan 2013 17:43:07 -0300
Message-ID: <CAJ2dSGSF1jRsdAawHnNo5JOyPxbbbLgrkukvMBrC03T-d6j0bg_at_mail.gmail.com>
Sure, what do you have so far?
hint: use the "describe" command from SQL*Plus to show the data type of each column.
hint2: The people in this mailing list are always glad to lend a hand, but we each have our own jobs and will not do yours for you. If you have something and you're stuck, this is the place to ask (there are a lot of very smart people here, and the rest of us may be able to help as well). If you come to us with nothing, you will get a funny yet unhelpful answer. (Thanks David for the comic relief)
Date: Wed, 9 Jan 2013 17:43:07 -0300
Message-ID: <CAJ2dSGSF1jRsdAawHnNo5JOyPxbbbLgrkukvMBrC03T-d6j0bg_at_mail.gmail.com>
Sure, what do you have so far?
hint: use the "describe" command from SQL*Plus to show the data type of each column.
hint2: The people in this mailing list are always glad to lend a hand, but we each have our own jobs and will not do yours for you. If you have something and you're stuck, this is the place to ask (there are a lot of very smart people here, and the rest of us may be able to help as well). If you come to us with nothing, you will get a funny yet unhelpful answer. (Thanks David for the comic relief)
You will find this applies to almost anywhere you ask.
Oh, and welcome to the list btw :)
Alan.-
On Wed, Jan 9, 2013 at 4:54 PM, oracledba <oracledba71_at_gmail.com> wrote:
> All,
> I am a newbie to Oracle.
> Can someone write a SQL to show tablespace's growth weekly like
> week1,week2,week3,week4 of each month?
> The table has the following columns and populated everyday.
>
> jobdate,srvrname,dbname,tsname,filename,allocatedspace,freespace
>
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 09 2013 - 21:43:07 CET