-
I am taking an existing SQL Server 2016 SSIS package and trying to add an Execute SQL Task. I'm suspicious that the task itself isn't the problem, but just in case, I'll explain it.It is a simple ......
-
Could anyone help with my datapump export. I've tried many combinations. But, I'm always getting:ORA-39001: invalid argument valueORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512: at &......
-
In OBIEE 12c there is a pivot table, built according to the format of a row with the attribute "Service", columns in the format "month" (from 1 to 12) -> "dedline_state&......
-
Here is an example of my text- I am trying to get TEXTPART3 AS THE ANSWER:TEXTPART1 : TEXTPART2: TEXTPART3 - TEXTPART4I used TRIM(LEADING ':' FROM REGEXP_SUBSTR('textstatementhere', ':.+?-')) - but ......
-
I'm trying to create a fairly simple stored procedure in Oracle 12.2 DB:create or replace procedure list_tables ( p_src_schema varchar2)as l_src_schema varchar2(30) := upper(......
-
I have a table xml_table_date. Below is the structure and sample data in the table.But I want to insert multiple xml files (here it is 9) into the table in one go. These files resides in a DB ......
-
Due to the audit security, If I wouldn't revoke the privilege from the public rolecan I change the default role in the Oracle database from 'PUBLIC' to another default group?then I create a new user ......
-
I am looking for scope where i can send data from oracle db to AWS Data exchange without any manual intervention?...
-
I am trying to create the following Materialized View with ENABLE ON QUERY COMPUTATION but I can't find where is the issue.I have three master tables with the corresponding materialized view logs and ......
-
I am learning recursive with in Oracle.Based on HR Schema from https://github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sqli wanted to create query, which will create a tree of employee-......
-
I'am staring using Oracle Developer Tools for Visual Studio Code but miss something versus what i did in past with sql server tools:Let's say i have a table whit this nameT_PREFIX_TABLENAMEI'am ......
-
I'm using Entity framework 6 with Oracle 11g2.I have a FLOAT(126) column in my database (which I'm not allowed to modify) and I want to map this value to my entity.So I use a decimal and, in my ......
-
This is just an example. I'm building this dapp where I have a start date and an end date and every day I want to get a random number from an oracle. If at some point the sum of the numbers I get ......
-
I've recently upgraded to Oracle 19c from 11g - I have a C# project which uses Entity Framework 5 to connect. This used to work when connecting to the 19g database but since the migration it now no ......
-
I'm trying to insert a row by selecting some datas from another table.insert into spb (id_barang,nama_barang,qty,lokasi_tujuan,lokasi_asal,waktu)values((select stg.id_barang,stg.nama_barang,......