I am new in Oracle.
I want to convert this in Oracle.
ALTER PROCEDURE [dbo].[GetAllLocationDetails]
@nodeID nvarchar(100)
AS
BEGIN
;WITH PR AS
(
SELECT nodeID,name,devtypeID,parentnodeID AS parent
FROM NODEDETAIL c
WHERE parentnodeID = @nodeID
UNION ALL
SELECT c.nodeID,c.name,c.devtypeID,c.parentnodeID
FROM NODEDETAIL c
INNER JOIN PR r ON c.parentnodeID = r.nodeID
)
SELECT latitude,longitude,LOCATION.nodeID,PR.name,PR.devtypeID from LOCATION
JOIN PR on LOCATION.nodeId = PR.nodeID
END