Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonStored procedure to hash a text column in a table with one of the hashing methods
Hello Experts,I have written the function that hashed a string but I donot know how to use this function to take in a column from another table to hash that column and then insert the hashed value into another hastable.any help will be appreciated,here is my h...
Chris SaxonSELECT Statement With Cursor In The Condition
HelloI have a use case, which has the following steps:1. get a list of account keys using a function <i>get_keys</i>;2. select results from a table where account keys <b>NOT</b> in the function results i.e.<code>SELECT * FROM accounts WHERE account_key NOT IN ...
Connor McDonaldCannot read external table or read using utl_file.get_line on Windows 10 with Oracle 18c
I just upgraded to Oracle 18c XE from 11g. I have an external table that worked fine on 11g, but I keep getting the following errors on 18c.ORA-29913: error in executing ODCIEXTTABLEOPEN calloutORA-29400: data cartridge errorKUP-11604: no directory object spec...
Chris SaxonHow to find child or parent from data with only ID and Level
Hi Tom,I have this data <code>select 1 LineNumber, 1 mylevel, 10 id from dualunion allselect 2 , 2 , 11 from dualunion allselect 3 , 3 , 13 from dualunion allselect 4 , 3 , 14 from dualunion allselect 5 , 4 , 15 from dualunion allselect 6 , 2 , 20 from dualuni...
Chris SaxonHow can I get min_date and max_date, grouping by some field
Hi.I'm trying to build a query to get dates intervals. Let me explain it in a simple way.We have a table with this fields: <code>Soldier_ID | Soldier_Name | Location | Ranking | Start_Date | End_Date1001 Jones Texas ...