Skip to Main Content

Questions

QuestionUpdatedAsked

v19.22Requirement is to run some queries against the audit table at the beginning of the month to capture details about the previous calendar month.EVENT_TIMESTAMP in UNIFIED_AUDIT_TRAIL is timestamp(6) (not date)Is this an appropriate where clause to query th...
27 hours ago46 hours ago

Hi Tom,i have a question about the index fragmentation, on the famous white paper "How to stop defragmenting and start living: the definitive world of fragmentation" by Bhaskar Himatsingka and Juan Loaiza, on section 4.2, they provide a script to tell if the i...
27 hours ago23 years ago

now i have json response from oracle service like following code{ "Status": null, "RequestNumber": null, <b>"validationResults": [ { "code":E1000, "details":'Validation Error' } ]</b>}now i can read keys Status and reque...
2 days ago2 days ago

I'm trying to follow along with the live lab 'Build a 'Doctor Appointments Made Easy' App using Oracle APEXIntroduction' to get to know the new Workflows in Application Express. In Lab 9 task 6 I run into an error in the Check Appointment Fee activity: ORA-018...
2 days ago8 days ago

Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me ...
3 days ago7.4 years ago

Problem StatementI am working with a large dataset (~11-12 million records), where I need to identify key out-of-stock (OOS) event dates for different products (MASTER_ID) across multiple marketplaces (MARKETPLACE_ID).Each record in the DETAILED_OOS_EVENTS tab...
4 days ago8 days ago

Oracle Version: Docker Image container-registry.oracle.com/database/enterprise:19.19.0.0Setup Script (to enable logminer)<code>SELECT log_mode FROM v$database;SHUTDOWN IMMEDIATE;STARTUP MOUNT;ALTER DATABASE ARCHIVELOG;ALTER DATABASE OPEN;SELECT log_mode FROM v...
5 days ago5 weeks ago

========= Dump for incident 2526042 (ORA 7445 [qcdlgcd]) ========[TOC00003]----- Beginning of Customized Incident Dump(s) -----Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x4] [PC:0x7FF87F3C490B, qcdlgcd()+75]The database prompts a socket error, a...
5 days ago8 days ago

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...
5 days ago9 days ago

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 ...
5 days ago9 days ago

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...
5 days ago9 days ago

I was recently asked to find out why an SQL in our web solution took so much time to execute.- The SQL involved querying vast amounts of data- Without the expression involved in the query which took much time, the SQL took less than a second to execute.- Our D...
8 days ago8 days ago

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...
8 days ago8 days ago

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...
8 days ago8 days ago

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? ...
8 days ago24.5 years ago

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"...
8 days ago8 years ago

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

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

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 ...
11 days ago12 days ago

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'); :...
2 weeks ago2 weeks ago