issues I face at the workplace I love-hate & then forget about, just to face them again. solely for personal ref, please be cautious :) know a better solution? help me learn :D 0xweathered@gmail.com
nah, using sample schema is way easier actually, lets go to HR lets say i want to make a stripped down table identical to the EMPLOYEES table, paritioned, by DEPARTMENT_ID column. so if i am using the HR.EMPLOYEES table, SELECT COUNT(DISTINCT DEPAR...
continuing from sql | how NOT to avoid multiple identical subqueries in the SELECT clause these won't work if your db is older than 12c. if it is lower, i guess the how NOT to is the how to, not an expert don't quote me on that. and no i don't want ...
running 12c or higher? how to inline subqueries in SELECT clauses, or simply scalar subqueries, as you can guess by the name, is used to return a single value. but what if, i am having to query a specific table, writing identical subqueries to fet...
not the best place for explanations here, the below query shows the number of open cursors present in a session. if the number reaches the db parameterOPEN_CURSORS, ORA-01000 is thrown. OPEN_CURSORS := number of cursors each session can have open, pe...
one day a dba reported high resource usage by a query, but it was 'well-optimized' and the runtime was as expected, then what was wrong? logical read was high. to calculate logical reads made by a query: DECLARE READS NUMBER; OUTPUT NUMBER; ...
there has to be an easier way other then CTRL+C CTRL+V, right? CARTESIAN QUERY SELECT X.* FROM ( 'INSERT SELECT STATEMENT HERE' ) X, (SELECT 1 FROM DUAL CONNECT BY LEVEL <= 'NO OF REPLICATIONS'); example: SELECT T.TABLE_NAME, ...
DBMS_UTILITY.EXPAND_SQL_TEXT
sqldeveloper only
had to turn a row value (which was a comma separated list) to a column of values solution was this query, although it would be much better to create a stored procedure or a function instead using this query directly: SELECT SUBSTR ( :P_STR, ...