Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set unused column

661723Sep 5 2009 — edited Sep 5 2009
Sir

i am new to database.I am doing an oracle course on 051.My oracle faculty is saying 
Set unused column
option will hide the column for-ever.user can't retrieve it again.
what i believe if a statement is hiding a column there must be some option to regain it.

Is there any option of to make an unused column to reusable again?
This post has been answered by JustinCave on Sep 5 2009
Jump to Answer

Comments

SmithJohn45

can you give some " sample data " like this:

with t as (Select 'account01' as account_name, '1990' as year, 'Jan' as month from dual
           Select 'account02' as account_name, '2000' as year, 'Feb' as month from dual
)
select ( your query here ) from t;

the seniors can help after checking the actual results of your query will return.
Help seniors to help yourself...

Stax 
SQL> ed
Wrote file afiedt.buf


  1  with t (account_name,year,month,sal) as (
  2   select 'u1','2022','January',150 from dual union all
  3   select 'u1','2022','February',200 from dual union all
  4   select 'u1','2022','March',300 from dual
  5  )
  6  select
  7    t.*
  8   ,sum(sal) over (partition by account_name order by  to_date(month||year,'MonthYYYY','NLS_DATE_LANGUAGE=AMERICAN')) ssal
  9* from t
SQL> /


AC YEAR MONTH           SAL       SSAL
-- ---- -------- ---------- ----------
u1 2022 January         150        150
u1 2022 February        200        350
u1 2022 March           300        650
1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 3 2009
Added on Sep 5 2009
#11g, #9i, #sql, #sql-developer
5 comments
36,132 views