Home » SQL & PL/SQL » SQL & PL/SQL » How to check if list partition exist
How to check if list partition exist [message #273193] Tue, 09 October 2007 07:28 Go to next message
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,
Re: How to check if list partition exist [message #273194 is a reply to message #273193] Tue, 09 October 2007 07:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to check if list partition exist [message #273211 is a reply to message #273194] Tue, 09 October 2007 09:30 Go to previous messageGo to next message
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.

Laughing
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 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, of course.

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

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


Current Time: Wed Dec 07 22:05:54 CST 2016

Total time taken to generate the page: 3.06445 seconds