Hi I am a beginner to PL/SQL and I have my PL/SQL code for importing a csv file to my GLOBALTERRORISM Database, this is the final version of my code until now.
My problem is the script output kept giving this error:

I have two cursors I am comparing. I would compare cursor1 if exists in all rows of cursor2. I tried below but it seems stopping at 1st match.

I am creating a cursor inside a procedure ; the exceptions are not working inside procedure while when i am independently running the cursor exceptions are working fine

Good afternoon
How to create a function. I need to make a selection from it.
Knowing the parameters the number of days on which the deposit is opened
The amount must be offered to the client as interest on the deposit.enter image description here

I’m trying to build a query for me to use as a template for running data extracts & give me runtime information.

I am using ELF file to load the data to database with CTRL file. If the last field in the segment having CHAR(13) and/or CHAR(10) then the data is stored with CHAR(13) and CHAR(10). It is giving any error while processing the data.
Need to remove CHAR(13) and/or CHAR(10) if found at the end of the field in the segment.

Newbie here. I’m sure the answer is out there, but I don’t know what to look for…

I am new to plsql and am trying to understand what the code below does. What does the 942 mean and why would someone want to use the code below? Thanks.

I am trying to make a JSON_OBJECT that stores my data from my table. I just have no idea how to append data after the creation of JSON_OBJECT. the reason of I did not include the two remaining columns is with regard to hired_date and emp_status, I will make some if else condition before adding on the json_object.