sql wizard - how to get sql statement's guideline

[baptman22003]

I am looking for a guideline to help
me when writing sql statements through
the plsql developper sql wizard's window.

It seems that a plugin exists, but where to find it?

In fact, I need a guideline that could help me by providing examples, explanations on how to use a specific statement such as : "connect by prior : research for childs or relatives... in examples : connect by prior nrelative nchild
start with ..."

thanks for help.

 

[Marco Kalter]

There are no wizards for hierarchical queries. In general you can use the built-in Query Builder or the Active Query Build Plug-In to interactively build queries.

 

[baptman22003]

My question was not clear.
I would say that I am looking for an Oracle help usable through the Query Builder in plsql Developer, such as the shortcut Ctrl+F1 in many programs.

 

[Marco Kalter]

Okay, I see. I have added this to the list of enhancement requests.

 

[baptman22003]

This is not a big deal, I will use an Oracle documentation. Thank you for your answer.

 

[Gustavo]

If you have access to the Oracle Documentation, you could choose which "books" to map in PLSD. Then you could just press F1 over any keyword to get the desired help.