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
I living problem in my query. When i add ROUND and DECODE query takes too long time but when i delete directly return value. When i search for sql advice no any
How to export output in a CSV format through a procedure. My output is stored in v_output variable Please find below query Declare view_name VARCH
I am really confused with PLSQL error messages The following errors are returned: Error at line 13: PL/SQL: Statement ignored 1. create or replace TRIGGER tr
Using PL/SQL (Oracle 11gR2) I want an IF statement that tests if a string contains 1 or more lower-case letters. PL/SQL pseudo-code: declare v_string varchar2
I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. Before this I was using Oracle SQL developer and I was able
I am running the following in the Scott schema: SET serveroutput ON; BEGIN FOR c_Emp IN (SELECT * FROM emp) LOOP dbms_output.put_line('The record processed by
I have a problem with returning a json object from a REST method in Oracle Apex. Apex puts an escape character in front of every quotation mark and hence the js
A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why? INSERT INTO CUSTOMER VALUES (1,'MALADY','Claire','27 S