Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Tom KyteSQL Query with dynamic number of columns
Hi Tom,I have a table like thiscreate table temp1(f_name varchar2(100), f_date date, f_amount integer);Records in this table will be like this:Ajay 15-JUL-02 500Bhavani 15-JUL-02 700Chakri 17-JUL-02 200Ajay ...
Chris SaxonSpooling data to .csv file via SQL Plus
It is probably apparent from my job title that my role is far from a dba. I am, however, a frequent user of Oracle SQL Developer. I work in mass appraisal and use SQL Developer to select, update, insert, delete, etc., on a regular basis. I would like to bring...
Chris SaxonJSON_VALUE() and JSON_TABLE(...COLUMNS...NUMBER...) honour NLS_NUMERIC_CHARACTERS while they shouldn't.
The following shows that the same (JSON) table data and the same queries yield different results when different NLS_NUMERIC_CHARACTERS are used.The above sentence is no surprise, obviously, but in this case I consider the behavior to be wrong; Please explain w...
Chris SaxonOracle Partition SPLIT Issue
Hello,I have a production problem for which I need your inputs.Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production1) There is a monthly Partitioned Oracle table with monthly Partitions created at during table creation.2) The a...
Chris SaxonTroubleshooting heavy hash joins
Hello Chris, Hello Connor.I know that hash join performance might suffer a lot if it has to store the hash table on a disk, but I have no idea how to check if that's happening and that is the reason a query is slow.Admittedly I do not know much about memory us...