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
When I'm trying to import data from excel to Oracle SQL. I keep getting an error Data is not compatible with column definition or is not available for a not n
Query the name of any student in STUDENTS who scored higher than 75 marks. Order your output by the last three characters of each name. If two or more students
I want to select only one row from a table. This row holds the maximum number in the table. I have tried to use MAX Fun but it didn't work for me. I use two ta
We have a new database server on RHEL 7 and Oracle 12c. The old database server is RHEL 4 and Oracle 10g. I need to dump the data using the 12c client from the
I have one requirement START_DATE : 03/01/2018 END_DATE : 31/01/2018 I need a query which will list all the weeks starting date and end date between these two
I am really curious why this happen: Oracle cloud instances cannot communicate by default with each other via private ip within the same VCN subnet. Is it again
In an Oracle database there's a big PL/SQL procedure being executed periodically that copies data from one DB to another one through a database link and it is f
I'm getting this error on vb6 when trying to connect to an oracle database, debugging puts me in this line, oracon.Open, here's my connection string. Provider=
I'm trying to parameterize a raw SQL query for an Oracle synonym (non-entity) in EF 4 and I am having some problems. Currently I am doing something like the co
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
I ran the simple select query in the command prompt,but the output rows are not coming in a single line. See below: SQL> set pagesize 2000 SQL> select *
How can we convert a string of any length into a comma separated string with comma after every n characters. I am using Oracle 10g and above. I tried with REGEX
I try to reach a WebService provide by a secured site with a TLS 1.2 certificate encrypted that i exported and add in a wallet. First i try to reach the site wi
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
I want to save SQL/PLSQL queries, which are being executed by a user. I use the below, and have to use append at the end of the statement as well as saving at
I have a ton of columns I am trying to aggregate together and most of them have NULL values. I want to separate values that do appear with a ';' but I cannot fi
Hi i'm using SQL Query in ORACLE db. How can i use the function REGEXP_SUBSTR (oracle SQL) to create a new column with name "VOIE" that contains just the type o
I have a parameter created for a stored procedure looking to allow user to pass in multiple inputs. create procedure sp1 (p1 in varchar2) as begin select proc
I have my ORACLE table with structure as desc extraction_log1 Name Null