Ask The Oracle Mentors

Recently Answered

	Stored 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...
	SELECT 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 ...
	Cannot 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...
	How 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...
	How 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 ...