Geek Articles

Categories

 

Subscribe

Daily Updates Subscribe geekarticles update via email Subscribe geekarticles update via RSS

 
GeekArticles FAQ Oracle FAQ

Partition name in Result set?

Author: asktom.oracle.com | Published: 7th Feb 2008 | Visited: 44 times | Add Comment
Filed in: Oracle FAQ

Hi, I need to know if there is a way to return the name of the partition that a row of data is coming back from. Regards, Clark

Read Article
 

Sponsored Links

 


Related Articles

 Convert Query Result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connect ...

 Indexes on single Partition of the table I have a table which has been partitioned by the months.Also in the same table i have an indexes in 4 columns. I used partition as we will be loading the data everymonth. We will be having around 9 million rows everymonth. While inserting the rows ...

 11g SQL Result Cache vs times Ten hi Tom A few monthes back i designed an architecture for one of our client. Then the main problem was their centeral database an Oracle 9i has so many problem that it was not possible for them to close it or ask us to redesign the system before w ...

 "Return value might be undefined" error is shown even if the very first line of the function explici... QC#: 51078 Version: 11.0 Status: Open defect, requires resolution Resolution: Bug is a duplicate (must note dup bug #) Description: "Return value might be undefined" error is shown even if the very first line of the function explicitly sets the funct ...

 Strange Compiler Result QC#: 50151 Version: 11.0 Status: Open defect, requires resolution Resolution: Need more information/demo/steps Description: Hi, I see a strange behaviour with Delphi 2007 Update 1: While debugging my program it seemed that one line of program code w ...

 0*-1 gives a result of -0 QC#: 51208 Version: 11.0 Status: New defect, requires tester review Description: I noticed half way through a program I was debugging that one of my variables was set to -0. This occurs when multiplying a variable set to 0 and a constant ...

 Function Result as TDynByteArray fails with 4 zero bytes QC#: 7628 Version: 7.0 Status: Closed defect, no action required Resolution: Bug has been fixed Description: First of all - excuse my bad english... i have created a webservice with a server and client application and used a TByteDynArray to transfer ...

 archive partition Hi Tom; I am building a new database in Oracle10g that will receive about 300GB per day in engineering data. I have about 90TB of EMC storage connected to 2 Sun 6800s and a Sun L700 tape library. I plan on partitioning by day. I need to keep 180 ...

 Add partition When I add a partition to the existing partitioned table, how do I deal with the indexes and triggers? Do I need to disable all of them and reenable them. Thanks in advanc ...

 Switching Type Library language type can result in an Exception QC#: 44305 Version: 11.0 Status: New defect, requires tester review Description: After having used the Type Library Viewer, if one changes the type of language display from IDL to Pascal, the IDE throws an exception. [210C351E]{tlib100.bpl } UIWrite. ...



Next: How to change repeat_interval for GATHER_STATS_JOB in 10GR2



Post Comment

Name:


Email:
 (Optional. Used for Notification)

Title:

 
Comment:


Validation Code:
 <=>  (Enter this code in text box)





Latest Articles

 

Popular Articles

Sponsored Links