OraFAQ Forum: SQL & PL/SQL » How to check if list partition exist

Home » SQL & PL/SQL » SQL & PL/SQL » How to check if list partition exist

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

How to check if list partition exist [message #273193]

Tue, 09 October 2007 07:28

nj121
Messages: 1
Registered: October 2007

Junior Member

Is any way we can check if List partition exist for certain parameter? I know we can look at user_tab_partitions table but Highvalue Field is Long datatype so can't use that in where clause...is any other way we can check through query?

thanks,

Report message to a moderator

Re: How to check if list partition exist [message #273194 is a reply to message #273193]

Tue, 09 October 2007 07:38

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a procedure that takes the long value put it in a varchar2 and return this varchar2.
Then call this function in your query.

Regards
Michel

Report message to a moderator

Re: How to check if list partition exist [message #273211 is a reply to message #273194]

Tue, 09 October 2007 09:30

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Michael,

I think you meant function not a procedure.

Quote:

Create a procedure that takes the long value put it in a varchar2 and return this varchar2.

Regards

Raj

[Updated on: Tue, 09 October 2007 09:31]

Report message to a moderator

Re: How to check if list partition exist [message #273228 is a reply to message #273211]

Tue, 09 October 2007 10:52

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, of course.

Have a look at "Long to Varchar2 conversion" thread on AskTom.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-00923 From keyword not found where expected
Next Topic:	Help me - Data Fix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 04:53:35 CST 2024