Needing to know if this is possible. I'm trying to get a hierarchical output looking like this: TITLE|CHART|FUND|ORGN|PROGRAM S |S |null|null| S |S
create or replace function auditif return number as l_filter_count NUMBER; begin EXECUTE IMMEDIATE 'EXPLAIN PLAN FOR ' || SYS_CONTEXT('USERENV','CURRENT_SQL')
I'm planning to write a pl sql pseudo code procedure a gets all records from emp and is passed to procedure b procedure b getting called inside from a , is tra
I'm running below code and getting below results but I want to remove ,, and after ,, texts from email address and that email address should show in UPPER(PT_PA
Problem : I have a view which was significantly slower earlier(fetching 50 records took 25sec) Made some code changes and performance increased by a lot( 50 re
I am writing this code which throws an error in primary key: DECLARE CURSOR A1 AS SELECT TRANS_DET_ID, (SELECT MAX (NVL(TRANS_DET_DET_ID, 0
I want to write a programm that first checks if a column is only populated with NULLs before updating the column. I have written what I thought should work, how
I have a function which is not working as expected. How can I modify to get the desired output? CREATE OR REPLACE FUNCTION f_get_all_programs_test( pidm in num
How should I iterate over a table of objects like this? CREATE TYPE SOME_OBJECT AS OBJECT ( ATTR1 VARCHAR2(20) , ATTR2 VARCHAR2(30) ); / CREATE TYPE C_SOME_
So i have a query that i would like to execute through a stored procedure and export the output of the query to a CSV file. But only the last column name is not
I'm working on some Oracle DB problem. Is there any possibility, to check if table or column exists, before I want to modify it? If it doesn'
I'm working on some Oracle DB problem. Is there any possibility, to check if table or column exists, before I want to modify it? If it doesn'
TABLE: Column name Data type Constraints DEPARTMENT_ID NUMBER(5) PK DEPARTMENT_NAME VARCHAR2(25) NOT NULL LOCATION_ID VARCHAR2(15) I have tried this. But stil
I'm looking to create a package, already have a working procedure. Working on a function, step by step and I have encountered an ORA-06575: Package or function
There are two tables given: 1) employee(eno,ename,basic,da,gross) da=basic*(5.0/100) gross = basic+da 2) sal_hist(eno, sys_dt, old_basic) How to write a
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production I am creating an Oracle job where I need to hit a procedure for every 30 minutes,
I have string such as A~B~C,D~E,F~G~H,I. The string is comma separated and then each comma separated substring is ~ separated. There is no limit on the number o
I'm currently creating an app in Oracle APEX and for some unknown to me reason while trying perform UPDATE/DELETE action by clicking on 'edit' button in the rep
Here is a fairly simple query that is throwing this error: SELECT RR.REQUEST_ID FROM CCS_REQUEST_RESPONSE RR INNER JOIN VW_STUDENT_CURRENT_AND_HIST VW ON RR.S
I've looked up questions here as well as looking online and watching videos but I'm still confused exactly what IN, OUT is. The reason I'm asking is because I'm