Questions

I get a .csv log file dropped from a microsoft server to a linux server using winSCP. The column REASON, is enclosed with "" and includes LF. Here is a 2 record snippet of the file: 5826431,5826431,,,New,17255483,,,,2e4cf893-078d-45b3-b548-2dc3c970ff25,5826431...

I was loading Large Data into a newly created table in Toad For Oracle 16.3 using SQL Loader with an Excel Data but i got error "Rejected - Error on table SCH_STRUCT_FIN.OFFSHORE_INV_COMM_MEETING_DATA, column COLLATERAL_FUNDING_REQUIREMENT . Field in data file...

If a SQL statement in pdb container A is <b>exactly</b> the same SQL statement as in pdb container B, will they share the same execution plan even though the owner of the tables and the user owning the session (including GTTs) will be different in each contain...

In Oracle Release 19 Document: Database SecureFiles and Large Objects Developer's Guide (https://docs.oracle.com/en/database/oracle/oracle-database/19/adlob/LOB-storage-with-applications.html#GUID-B82B3C24-1FAF-4661-96A0-28241FD2A052)there are following des...

Can I join a PL/SQL table with database tables? If so, what's kind of PL/SQL table I can use: index table or nested table? ...

hi ,when I am loading data for one column value speeded in multiple columns and its failed.Here is the example and syntax for control file,record failing due to values in multiple lines for DESCRIPTION column"0","test0","123235","testitem0","test","sample0""1"...

Hello Tom ,We have been facing a performance issue for some of the sql's in our system .We have a procedure called "<b>process_xyz</b>" which is being called our batch system and Web application ( OLTP) system . It uses a global temporary table to stage the ...

I need to union two database querieres for an export job.Any idea how this is formatted on a par file?...

HiMy question is if you were planning or would consider creating a course on Fast formala and Oracle BI publisher?Thank you...

Hi,We have a partitioned table that is very critical to the operation of a 24/7 OLTP application. Data is mainly only INSERTED into this table and every transaction that happens writes to this table. Data in this table is usually not required after a month or ...

declare a number;begin if :qy.div_name is not null then if :qy.emp_name is not null then update salary_processing set p_date :='qy.p_date where emp_code :='qy.emp_code and div_code :='qy.div_code and yearmonth :='qy.yearmonth; forms_ddl('commit'); :...

Hello Connor/Chris,Hope you are doing well.I came across MOS note ORA-6502 Research Events (Doc ID 2911572.1), which claims to recommend an option to enable trace to get more details about ORA-06502 error.However, I am not able to reproduce the behaviour on 19...

Hello,We use Oracle 19c with c# ADO and EntityFramework.We have performance issue when use ALTER SESSION SET NLS_COMP = LINGUISTIC NLS_SORT = BINARY_CI;Our system use this for all queries. I use this simple table for test:<code>CREATE TABLE app."Customer" ( "...

Would you happen to have a database feature comparision matrixbetween postgresql and oracle.I would really appreciate if you could provide me with one.thanks. ...

hi folks,I am very happy about the new enum domains in PL/SQL. They are very useful and can make the code much more maintainable.But I struggled over a problem. When I create an enum domain like <code>create domain MY_TEST_ENUM as enum ( text1 = 'text1', tex...

i have two questions about the temporary tablespace.1.) if i'm running out space on temporary, how could i know which user or transaction is using the temporary tablespace.2.) Sometime, it happens to me that, obviously no transactions running, but the te...

I would like to create a table in an Oracle 19c DB (on premise) that is optimally designed for many parallel DML queries (INSERT/UPDATE).What do I have to pay attention to?Does partitioning help, with different tablespaces?How must sequences be created or shou...

Dear TomI cannot create an index on a virtual column of type RAW or RAW(30). I've used virtual columns several times in the past and I also indexed them, with no issues so far. This this the first attempt to do so with a RAW column, but I fail.Why do I want to...

I have a simple table with numeric column<code>create table foo (i integer);/</code>In my apex application I have a very simple automation(scheduled, always, daily at midnight) and my action code is:<code>begin insert into foo values (1); commit; exec...

I have the following query. I am wondering why, oracle sufixes "000" with the given timestamp value when I format it. SQL> alter session set NLS_TIMESTAMP_TZ_FORMAT='dd/mm/yyyy hh24:mi.ssxff' ;SQL> alter session set nls_timestamp_format='dd/mm/yyyy hh24:mi.ssx...