SQL & PL/SQL :: Get All Possible Paths?

Nov 4, 2012

Suppose I have 4 Inputs 'A','B','C' and 'D'.

Problem is I have to get all the path from
1st 'A''B''C''D' to 'A'
2nd 'A''B''C''D' to 'B'
3rd 'A''B''C''D' to 'C'
4th 'A''B''C''D' to 'D'

For 1st one all the possible paths will be:

ABCD --> ABC --> AB --> A
ABCD --> ABC --> AC --> A
ABCD --> ABD --> AB --> A
ABCD --> ABD --> AD --> A
ABCD --> ACD --> AC --> A
ABCD --> ACD --> AD --> A
... same approach for second path and so on...

The inputs may vary in number, like they may be 'A','B','C','D','E'... so on.

Note: This may not seems to be a Oracle problem, but I have to do it in Oracle as my further steps will depend on this.

View 5 Replies


ADVERTISEMENT

Testing Fields With Multiple Paths?

Jan 18, 2007

My task is to test a field in a certain database. We shall refer to the field as ship_to. There is an algorithm for which the field ship_to is populated and higher up in the algorithm, a variable we shall call X is created. The algorith states that I should assign the variable to ship_to unless X is = -1. If X is = -1, the algorithm continues with multiple joins and assignments. What would be the best way to go about coding this solution. There are 4 individual paths. I have only described the first path, but they are similiar in structure. I was thinking of using either Case's or decodes?The field ship_to is a number. I have already created a statement to test the sum of the Target, but now I need to test the entire algorithm to see if it too sums the Target.

View 1 Replies View Related

RAC & Failsafe :: Changing Disk Paths In ASM

Jul 13, 2012

We are about to undertake a storage migration of our RAC environment from EMC to XIV storage.

The migration method we are using means that we will be presented with identical disks post the migration, however the UNIX paths to the disk devices will be changing. Using our migration method it is not possible to present the old and new devices at the same time.

Therefore once the migration is complete i need to update the device configuration to reflect the new paths. I believe this is done using the following techniques but I am unsure as some of the documentation is ambiguous and I have not done this before

Changing path to Voting Disks

crsctl add css votedisk <new_path_to_disk> -force
crsctl delete css votedisk <old_path_to_disk> -force

Changing path to OCR Disks

ocrconfig repair ocr <new_path_to_ocr>
ocrconfig repair ocrmirror <new_path_to_ocrmirror>

Changing paths to ASM disks

alter system set asm_diskstring='<new_device_path>' scope=both;

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved