All Questions
10,009
questions
0
votes
1
answer
32
views
Querying Json_Object_t using dot notation in Oracle 19c
I have a case where Json document is passed as CLOB input to a stored procedure.
I am converting it into Json Object as below
l_js_obj := JSON_OBJECT_T(p_js_clob_i);
Json:
{"Key1":{"...
- 153
-3
votes
0
answers
43
views
PLSQL, Can you help me understand this code? [closed]
--write a function where if the user gives option 1-4 and employee_id it will return the name in any format
Function name: custom_name
parameter (in): options,employee_id
data type: number
return: ...
2
votes
4
answers
48
views
Split String by delimiter position using oracle SQL 28.9 X 30.6
I have a string which contains a '48.6 X 90.6' at COLUMN DIE_SIZE. I want to split this string into size_x and size_y. I can only find a way to split the die_y
Example Strings:
DIE_DIZE
48.6 X 90.6
...
- 21
0
votes
1
answer
41
views
Oracle - Shell - Have a list of users to create in DB
In Oracle database, I have to create a list of users from a external SQL file - create_users.sql.
I am trying to automate a refresh process of data from one db to another db. I was successful in doing ...
- 31
2
votes
1
answer
62
views
Loading CSV files with double quotes in field values via Oracle Loader External table
Requesting your help and expertise on the below:
Oracle DB 19c on UNIX server
Requirement:
CSV files come in on a daily basis in a Unix directory (where the database resides) and gets loaded to a ...
- 51
0
votes
1
answer
36
views
Why the Cursor query is fetching records successfully but not fetching the values?
Below is the SQL package which is going to be a part of a script. In this package the cursor used is fetching sufficient records as required, but not working when I am incorporating in this package. ...
- 11
0
votes
1
answer
37
views
Fill up schema-level table, and use it with join
I have a schema-level record type and a schema-level table type, and I want to fill this table with records.
create or replace Type t_SLRekord As Object(OWNER VARCHAR2(128),
...
- 7
0
votes
1
answer
55
views
How to loop through multiple cursors in succession in PL/SQL
This is probably simple but I cannot find a good example online. I have 5 cursors I would like to iterate through in succession (loop through all of cursor 1, then loop through all of cursor 2, etc). ...
- 1
0
votes
2
answers
56
views
I got error saying result of string concatenation is too long [duplicate]
I am trying to insert data into table which have values more than 4000 character, to overcome with this i have made column qcnotes datatype clob on zzz_drop_result_718001 but i couldn't get it done.
...
- 15
0
votes
1
answer
39
views
Update TransactionId based on mapping table data
I have 2 tables:
Table 1: ProductTransaction (PK is both the column)
Here, TransactionId value options will be 1 or 2 or 3 | 1 and 2 | 1, 2 and 3.
Only 3 combinations are possible. ProductId 5 has ...
- 59
1
vote
1
answer
68
views
INSERT and UPDATE the Values into the table based on condition
I have 2 tables:
Table 1: EnrollmentTransaction (PK is both the column)
EnrollmentId | TransactionId
-------------+--------------
5 | 1
5 | 2
6 | 3
7 | 2
7 ...
- 59
0
votes
1
answer
35
views
Invalid Identifier error while using standard_hash function in oracle 11g
I'm trying to generate a hash based on a field but got the following error:
Query:
select standard_hash(pk_time) from schema.table
Error:
"STANDARD_HASH": invalid identifier
The column type ...
- 10.2k
0
votes
1
answer
40
views
Oracle own aggregation function in package
I created my own Oracle type and aggregation function from it:
As separate one, the function is created as:
create or replace FUNCTION MY_AGGR_FN (input NUMBER) RETURN NUMBER
PARALLEL_ENABLE ...
- 6,382
0
votes
1
answer
50
views
Error starting at line : 311 in command - DECLARE in oracle sql [closed]
I was coding coding in Oracle, when I encounter an issue Declare and syntax, but I don't know where is it
Error starting at line : 311 in command -
DECLARE
v_commune_id NUMBER;
v_district_id ...
0
votes
2
answers
87
views
INSERT OR UPDATE based on table data in single query
I have 2 tables:
Table 1: EnrollmentTransaction
EnrollmentId | TransactionId
-------------+--------------
5 | 1
5 | 2
6 | 3
7 | 2
8 | 3
8 ...
- 59