Now you could see the required columns added to your explain plan.ĭo I need to open different window all the time for checking explain plan for different SQLs? Using the right arrow, select the required columns from "Available column" and move them to "Selected columns". In your SQL window, the way you execute your SQL, press F5, it will open explain plan window, then follow step 2.įollowing the steps will point to the Preferences window.
Open explain plan window, on the bar you would see an icon at right end which looks like a spanner, click on it.ģ. Go to, Tools -> Preferences -> Window Types -> Plan WindowĢ. It could be done in either of these 3 ways :ġ. To get rid of such issues, all we need to do is, set the explain plan window preferences.
#Plsql beautifier online how to
How to include FILTER PREDICATES in the explain planĬ. I don't see ACCESS PREDICATES in the explain plan windowī. There are lots of questions on explain plan like,Ī. Nice demonstration about DATE, TIMESTAMP and INTERVALS by Tim Hall. A good explanation by Ed Stevens about common myths about NLS DATE format, settings and precendence order.Ģ. Read the following links for further clarity,ġ. Play around with the NLS options for more understanding. OR user defined as MM/DD/YYYY and gets the output displayed as required. User then changes it to Oracle format which is as defined by the Oracle environment (NLS_DATE_FORMAT). It is due to the following settings of DATE. User complaints that he gets output of "SELECT TRUNC(SYSDATE) FROM DUAL" as DD-MM-YYYY, Else, the output will be displayed per the NLS settings of the client tool. We have 3 options for the DATE, TIME and NUMBER formats.įor all the three formats, only ALTER SESSION statement and session level format mask using SQL can override. All you need to do is, set the NLS settings properly per your environment needs. Such questions are all related to the NLS Options. "But my date format is not correct" OR "I do not see the time part" One of the most common issues is with the improper settings of NLS parameters.
0 kommentar(er)
