PL/SQL :: Path Between Two Siblings Node

Dec 31, 2012

I want to find the path between two nodes from oracle Hierarchical Table.

Consider the following case ---
NodeId --- ParentId
=============
1 >>>>>> 0
2 >>>>>> 1
3 >>>>>> 2
4 >>>>>> 3
5 >>>>>> 0
6 >>>>>> 5

Here I want to query in the database table that whether there is a path between node 3 and node 5 ? The previous query you provided work up to root node.

Here my expected result is 3-->2-->1-->0-->5

Again if I query in the table to get the path between 1 and 3 , I want to get the output in the following way -
1-->2-->3

So the query need to work in both the cases. Where root nod can act as an intermediate node or not.

how I can get it ?

View 3 Replies


ADVERTISEMENT

Forms :: Use Clause SIBLINGS BY On 10g

May 26, 2011

I would like use clause SIBLINGS BY on Forms 10g, but i don't use it how.

View 1 Replies View Related

How To Count Siblings In A Hierarchical Query

Sep 24, 2012

How to count siblings in a hierarchical query? I'm trying to get a listing of employees

SELECT LEVEL, last_name||', '||first_name AS Manager, count(employee_id)
FROM employees
START WITH manager_id IS NULL
CONNECT BY PRIOR employee_id = manager_id
GROUP BY level

This returns 4 levels. I'm wanting to add up the number of siblings under the level 2 instead of listing them all.

View 1 Replies View Related

Forms :: ORDER SIBLINGS Keyword No Accepted

Dec 5, 2010

This code run fine in Toad BUT giving me error in forms.

SELECT
LEVEL LOC_NAME,
LOCATION_NAME LOC_ID,
LOCATION_ID HLOC_ID,
HEAD_LOC_ID MUDRA
FROM AS_LOCATION_HDR
CONNECT BY PRIOR LOCATION_ID = HEAD_LOC_ID
START WITH HEAD_LOC_ID is null
ORDER SIBLINGS BY LOC_ID

The error is: "Encountered sysbol "SIBLINGS" when expecting one of the following:
by
The symbol "by inserted before the "SIBLINGS" to continue.

Is the SIBLINGS keyword not acepted in forms? What would be the alternative?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Query On Adding New Node To Existing 2 Node Cluster

Jun 15, 2012

current environment

Oracle VM 2 Node RAC cluster
Oracle 11G 11.2.0.3.0
Oracle 11g rel 2 GI

on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2

we shutdown vmorarac1 to clone it to vmorarac5

on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211

mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5

152.144.199.171 vmorarac1.pbi.global.pvt vmorarac1
192.168.2.30 vmorarac1-priv.pbi.global.pvt vmorarac1-priv
152.144.199.184 vmorarac1-vip.pbi.global.pvt vmorarac1-vip

[Code]....

Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2

152.144.199.210 vmorarac2.pbi.global.pvt vmorarac2
192.168.2.32 vmorarac2-priv.pbi.global.pvt vmorarac2-priv
152.144.199.211 vmorarac2-vip.pbi.global.pvt vmorarac2-vip

hostname change in /etc/sysconfig/network

On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1

addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing

View 3 Replies View Related

Data Guard :: How To Find Apply Node In RAC Two Node Standby DB

Aug 16, 2013

I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?

I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?

View 2 Replies View Related

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?

View 3 Replies View Related

RAC/ASM Clusterware Installation :: VIP Node Application Failing In Second Node

Jul 18, 2013

I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below

[root@Rhel52 bin]# ./crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy[root@Rhel52 bin]#[root@Rhel52 bin]# clear[root@Rhel52 bin]#[root@Rhel52 bin]# ./crs_stat -tName           Type           Target    State              Host------------------------------------------------------------------------------------ora.rhel5.gsd  application     ONLINE    ONLINE      rhel5ora.rhel5.ons  application     ONLINE    ONLINE      rhel5ora.rhel5.vip  application      ONLINE    ONLINE       rhel5ora.rhel52.gsd application    ONLINE    ONLINE     rhel52ora.rhel52.ons application    ONLINE    ONLINE     rhel52ora.rhel52.vip application     ONLINE     ONLINE      rhel52 [root@Rhel52 bin]#./runcluvfy.sh stage -post crsinst -n 

[code]....

View 0 Replies View Related

RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?

Sep 13, 2012

I would like get more details about single node RAC.. What is single Node RAC?..

1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...

is there any advantage using single node rac(other than online upgrade to full RAC).

View 3 Replies View Related

Add Third Node To Existing Two Node Cluster

Feb 3, 2012

I'm trying to add the third node to my existing two node cluster. In fact i succeded adding the node but i have the following problem:

-when i start node 1 and 2, everything is ok, but on node 3 startup one of the other nodes fails
-this happens in any combination: start 1 and 3, everything is ok. when i start node 2, node 3 fails

The asm configuration (disks, permissions, etc) is the same on all three nodes.find below the asm and crsd log details from the failure time:

alert_ASM.log
NOTE: enlarging ACD for group 1/0x124851d1 (DATA)
WARNNING: cache read a corrupted block group=DATA dsk=4 blk=1 from disk 4
+NOTE: a corrupted block from group DATA was dumped to /u01/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_rbal_4109.trc+
WARNNING: cache read(retry) a corrupted block group=DATA dsk=4 blk=1 from disk 4
[code]...

View 3 Replies View Related

Forms :: How To Set Dynamic Path In 6i

Aug 6, 2008

I am using Oracle Form 6i. I have created pdf file from oracle report. On view button, I have written:

host('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe C:dailypending.pdf');

I don't want to set this path on every machine. I want to set its dynamic path so that on which even I machine, I run the applicaiton, it will directly find AcroRd32.exe from any drive either C: or D: or anything else...

It might be Acrobat Reader 9.0 or 8.0 whatever version will be installed on client machine...I want to set path according to that..So that whatever version it would be, it doesnt affect the application..

View 4 Replies View Related

SQL & PL/SQL :: Retrieve The Path Of A Directory

Oct 27, 2011

I create a directory using this:

CREATE DIRECTORY xml_data AS 'c:\mytest';

How can I retrieve the 'C:mytest' in a select statement?

View 5 Replies View Related

Forms :: Path To Use DLL - Library Not Available

Oct 18, 2013

How to use the DLL? My DLL is loaded on the client host in the C: Documents and Settings USER webutil. When you try turning to the library, I get an error:

WUL-928 [CApiFunctions.set_invokeoncespec ()] EXAMPLE.DLL library is not available or does not contain a function MYFUNCTION

View 11 Replies View Related

SQL & PL/SQL :: Find The Longest Path

Mar 25, 2013

create table test
(
avarchar2(10),
bvarchar2(10)
)
/
insert into test values ('A', 'B');

[Code]...

We want to get the path from "A" to "E". In other words, if we start with any value of the column "a" we have to reach the "maximum" value of the column "b".

"maximum" in sense that we don't find the value of "b" in "a".

Example :
---------
E is not found in the column a, so E is the maximum of A.
- N is the maximum of K
- Z is the maximum of Q and the maximum of S

select ...
from ...
where a = 'A' should return E.

View 11 Replies View Related

How To Change Datafile Path

May 13, 2013

I need to change data file path, and i got some document also but one thing confusing me, we need to offline the Tablespace, so my concern is all the table space like system, sys, user, temp etc. need to offline and then alter the database?

View 9 Replies View Related

SQL & PL/SQL :: Query With Connect Path

Nov 11, 2011

I am working on a query as below:

CREATE TABLE FDL_SNOP_SCDHUB.TEST_CONN
(
NAME1 VARCHAR2(100 ),
VALUE1 VARCHAR2(4000 ),
ID1 VARCHAR2(200 ) NOT NULL
);
[code]....

I have tried with sys_connect_by_path and wm_concat

with mst as (
select id1,name1,value1 from test_conn c
where ((c.name1='WORKFLOW_TYPE' and NVL2(:p_workflow_type,decode(:p_workflow_type,' SELECT ALL',' SELECT ALL',c.value1),0)=NVL2(:p_workflow_type,:p_workflow_type,0))
or (c.name1='SOURCE_TYPE' and NVL2(:p_source_type,decode(:p_source_type,' SELECT ALL',' SELECT
[code]....

but unable to group it by Id, all comes under one column

View 6 Replies View Related

Import Oracle 9.2 Exp To 11.2 - How To Change Path

Dec 10, 2012

The source server (9.2) is /oracle/data/xxx the destination will be /u02/oradata/xxx how do I get the imp to change the paths.

I know you can't do db_file_name_convert, as that only works in dataguard with rman, and it looks like you can only set compatible down to 10.2, it's a very small DB, (5Mb) but it's a live license server DB, I need it intact.

I tried a straight import, but that just barfed with "IMP-00015: following statement failed because the object already exists:" on every statement.

EDIT: it's lying, the /oracle path doesn't exist, just FYI.

View 8 Replies View Related

How To Handle Spaces In Path Name Of File With PL/SQL

Apr 10, 2009

How do I handle spaces in the path name of a file with PL/SQL? This is what I am trying to do.

start f:folder namefolder name with spacesfoldernamescript.sql

I keep getting an error:

"The file 'f:folder.sql' does not exist."

Is there a special character I need to put in there for the spaces? How can I get this to work?

View 3 Replies View Related

How To Change Oracle TNS Listener Path

Oct 29, 2010

how to change this path:

F:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR

to this path:

d:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR

in the service ?

View 2 Replies View Related

Backend Database 10.2.0.3 - Upgrade Path?

Jun 6, 2012

we have a very critical application running and the backend database is 10.2.0.3. we are planing on upgrading to 10g to 11.2.0.2 and looking ways to look with minimal downtime off production. steps for upgrade with very minimal downtime of appliction?

View 2 Replies View Related

Windows :: Value For PATH Environment Variable?

Jan 23, 2013

what value exactly I need to give for the PATH environment variable in oracle 11g running on windows xp?

View 15 Replies View Related

SQL & PL/SQL :: Find Shortest Path With Visits

Jul 3, 2013

I am find about an algorithm of shortest path with visits certain nodes.I have a table of Links with this fields: ID_Link, City1, City2 and distance...You have informations about shortest path with visits?

View 9 Replies View Related

Forms :: Find Path In Oracle 6i?

Nov 1, 2011

how can i get full path in oracle 6i???

View 2 Replies View Related

SQL & PL/SQL :: Fetch File Path From A Folder

Oct 4, 2013

We upload a file on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible.

View 12 Replies View Related

SQL & PL/SQL :: ORA-29280 / Invalid Directory Path

May 13, 2012

I started working on utl_files. When i Am working on this topic I struck with an error: Quote:ORA-29280: invalid directory path. Below are the steps I followed to work on utl_files,

STEP1: connect sys as sysdba

STEP2: @$ORACLE_HOME/rdbms/admin/utlfile.sql

STEP3: create or replace directory utl_data_files as '/home/oracle/siva/data/'; --(the directory path is already exists in the OS)

STEP4: below is the code

DECLARE
out_file UTL_FILE.file_type;
linebuf varchar2(1999);
directory_name varchar2(100):='utl_data_files';
BEGIN
out_file:=UTL_FILE.fopen(directory_name,'emp.dat','W');
for emp_cur in (SELECT * FROM scott.EMP)

[code].....

STEP5: then it's giving the below result/error info

Quote:

SQL ERRORCODE IS:-29280
SQL ERROR MSG IS:ORA-29280: invalid directory path

PL/SQL procedure successfully completed.

View 2 Replies View Related

Forms :: How To Set Registry Path Under 6i In CentOS

Dec 26, 2012

How set the registery path under forms6i in Centos

View 4 Replies View Related

Forms :: Setting Output Path

Feb 1, 2010

Recently i faced with a situation of redirecting a report output to a particular path in my server, and then opening the output by using web.show_document.

I was successful in redirecting it too a path , however i am not able to open the file using URL. We should setup virtual path in orion-web.xml and proceed further.

I pointed the output to an existing virtual path as below in my orion_web.xml file.

D:OraHome_2 oolswebhtml

and tried opening the output through the url

<<<server_name>/forms/html/filename.extn>>>

however i was not able to add new virtual path here .

View 3 Replies View Related

Install SQL Developer / Set A Path To Java

Oct 16, 2012

i try to install the sql developer, and i need to set a path to java it show: "Enter the full pathname for java.exe"

View 4 Replies View Related

PL/SQL :: ORA-29280 / Invalid Directory Path

Sep 9, 2013

When i am running the below script i am getting error like Invalid directory path. how to check the path by using dbms_ouput.

error : ORA-29280: invalid directory path
ORA-06512: at line 34

DECLARE
l_out_file  UTL_FILE.file_type;
g_convert_crlf  BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
  l_buffer    VARCHAR2(32767);
  l_amount    BINARY_INTEGER := 32767;
  l_pos       INTEGER := 1;

[code].....

View 1 Replies View Related

Forms :: Use Only AcroRD32. Exe Without Using Proper Path?

May 10, 2013

i m using oracle d2k i want to open a pdf file given proper path of C:Program FilesAdobeReader 9.0ReaderAcroRd32.exe but i want to use only AcroRD32. exe without using proper path how i use it

View 6 Replies View Related







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