Toad for SAP Solutions supports SAP ASE, SAP HANA, SAP IQ, and SAP SQL Anywhere. So in a GUI if you select date, length(date) the results of the two can have nothing to do with each other, in sqlplus on the other hand they'll always correspond.įor the record PL/SQL Developer displays that date correctly as well. Take advantage of simple-to-use query builders and SQL editors, data-modeling functionality, powerful SAP database tuning, maintenance- and change-management tools, easy collaboration through Toad Intelligence Central, visual database maps and more. So for that the date will be implicitly converted to a char using the nls_date_format. Excel Into Oracle Using Toad Python And Oracle Database Tutorial Scripting For The. However it's rather meaningless in this case since length only accepts char parameters. SQL LOADER is an Oracle utility used to load data into table given a. The length works of course because it outputs as number. TOAD displays dates as calender objects in the data grid - that was probably never coded to go as high as 5249. The problem in this case is presumably due to the client code being unable to handle the particular year in this case. So no implicit conversion happens and the nls_date_format is not applied. When you select a date in TOAD for example it's fetched as a date into a date variable in the client (toad) code. Most GUIs can handle dates as dates though. SQLPlus always converts dates to strings when you select them since it's a simple text interface and can't handle dates as dates. The nls_date_format kicks in when converting a date to a string, either implicity or explicity without a format mask. Go to the menu Database Monitor SQL Tracker. I doubt that that is the problem, I also doubt it's anything really to do with the nls_date_format. How to use the Toad SQL Tracker feature Launch SQL Tracker from inside of Toad for Oracle.
0 Comments
Leave a Reply. |