| Function | Purpose | |----------|---------| | TO_DATE('2025-01-01', 'YYYY-MM-DD') | Convert string to date | | TO_CHAR(date, 'MM/YYYY') | Format date | | SYSDATE | Current date & time | | TRUNC(date, 'MM') | First day of month | | EXTRACT(YEAR FROM date) | Get year part | | LISTAGG(column, ',') | Concatenate rows into string | | DECODE(grade, 'A', 'Excellent', 'B', 'Good') | If-else logic |
✅ Query runs without syntax error ✅ Handles NULL correctly ✅ Uses proper indexes (implied by join/where order) ✅ Uses table aliases ✅ Output column names match expected format exactly ✅ No accidental Cartesian product
Write a procedure to increase salary by 10% for employees hired before 2015. Oracle Hackerrank Interview
Given an array of daily stock prices, return an array that shows the span of the stock’s price for each day. The span is the number of consecutive days before the current day where the stock price was less than or equal to the current price.
"Given a string containing digits from 2-9 inclusive, return all possible letter combinations that the number could represent. BUT, filter out any combinations that contain a substring of consecutive vowels." (Difficulty: Medium) "Given a string containing digits from 2-9 inclusive,
Oracle is a database giant. Consequently, their coding tests focus less on esoteric algorithms and more on and string manipulation . Here are the specific domains you must master:
Oracle typically uses HackerRank in two distinct ways: as a proctored and as a Live Coding Environment for technical interviews. Here are the specific domains you must master:
def main(): data = sys.stdin.read().strip().split() # or for line in sys.stdin: # process line