Home » SQL & PL/SQL » SQL & PL/SQL » oracle 11g issue (oracle11g,w7)
oracle 11g issue [message #572909] Tue, 18 December 2012 09:58 Go to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
I used below mentioned query in oracle sql developer.but it always displaying parent_id column only.Please help me Embarassed


select PARENT_ID,NAME
from TEST_TBL
start with PARENT_ID IS NULL
connect by prior NODE_ID = PARENT_ID;
Re: oracle 11g issue [message #572910 is a reply to message #572909] Tue, 18 December 2012 10:01 Go to previous messageGo to next message
BlackSwan
Messages: 23061
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: oracle 11g issue [message #572914 is a reply to message #572909] Tue, 18 December 2012 10:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59815
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because there is no other data.

And to be clearer than BlackSwan as the last time you answered her "I am not able to understand your mail" and paraphrasing the link:

With any SQL or PL/SQL question, please, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Use SQL*Plus and copy and paste your session, the WHOLE session.

In the end FEEDBACK to those that help you, we are waiting for you in your previous topics.

Regards
Michel

[Updated on: Tue, 18 December 2012 10:13]

Report message to a moderator

Re: oracle 11g issue [message #572916 is a reply to message #572914] Tue, 18 December 2012 10:13 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Dear michel,
Thank you for your reply.But if i execute like
select NAME,PARENT_ID
from TEST_TBL
start with PARENT_ID IS NULL
connect by prior NODE_ID = PARENT_ID;

means it is displaying name only.
Re: oracle 11g issue [message #572917 is a reply to message #572916] Tue, 18 December 2012 10:15 Go to previous message
Michel Cadot
Messages: 59815
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 18 December 2012 17:10
Because there is no other data.

And to be clearer than BlackSwan as the last time you answered her "I am not able to understand your mail" and paraphrasing the link:

With any SQL or PL/SQL question, please, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.


Use SQL*Plus and copy and paste your session, the WHOLE session.

In the end FEEDBACK to those that help you, we are waiting for you in your previous topics.

Regards
Michel

[Updated on: Tue, 18 December 2012 10:15]

Report message to a moderator

Previous Topic: ORA-01410 Invalid Rowid while selecting/refreshing Materialized Views
Next Topic: find the lock on particular date and time
Goto Forum:
  


Current Time: Fri Nov 28 02:49:50 CST 2014

Total time taken to generate the page: 0.08935 seconds