OraFAQ Forum: SQL & PL/SQL » using partition name with date function to

Home » SQL & PL/SQL » SQL & PL/SQL » using partition name with date function to_char(sysdate,'ddmmyy')

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using partition name with date function to_char(sysdate,'ddmmyy') [message #204188]

Sat, 18 November 2006 12:39

gjayasekar
Messages: 45
Registered: October 2005

Member

Hi,

I am using table with partitions
here i want to select the current partition name with the date function to_char(sysdate,'ddmmyy')

Please suggest me.

partition name is p_18nov2006 - here partition are created range by (date_time) column.

select * from prod partition(p_18nov2006);

Report message to a moderator

Re: using partition name with date function to_char(sysdate,'ddmmyy') [message #204200 is a reply to message #204188]

Sat, 18 November 2006 18:01

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Just do:

SELECT * FROM prod
WHERE partcol = to_char(sysdate,'ddmmyy')

You cannot dynamically select the partition from wich you want to select in a straight SQL.

Ross Leishman

Report message to a moderator

Previous Topic:	Problem ... Update Query with join two tables
Next Topic:	Grouping and Merging Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 20:49:52 CST 2024