Skip to Main Content

Questions

QuestionUpdatedAsked

Hello Chris, Hello Connor.I have a view with a schedule of some kind of launches:<code>create or replace view v_schedule as select trunc(sysdate) + interval'1'minute * level as plan_date from dual connect by level <= 100000</code>And a log of actual launch dat...
7 hours ago6 days ago

Sorted input:<code>select regexp_replace( 'three0, three, two, two, two2, two3, three, three, three, one1, one1', '([^,]+)(,\1)+(,|$)', '\1\3') from dual;three0, three, two, two2, two3, three, one1</code>unSorted input:<code>select regexp_replace( 'three0, thr...
12 hours ago3.1 years ago

Hi Tom,in our ETL tool we have a process by which a flat file is read and transformed. A table is created with columns to hold the flat file content and columns for the functions that are applied sequentially per row. the file content is loaded via bulk copy. ...
34 hours ago6 days ago

Hi Tom,How would you recommend generating PDF documents from within "plain" PL/SQL?Thank you,Dieter...
35 hours ago12.3 years ago

Greetings,I have a few questions regarding how Oracle by default encrypts the password when sent to the Oracle databases. (https://asktom.oracle.com/pls/apex/asktom.search?tag=password-security-during-logins&p_session=117601880297172)First, please confirm tha...
42 hours ago6 days ago

Hi, I saw various sort options in tkprof.sort=(prsela,exeela,fchela)sort=PRSDSK, EXEDSK, FCHDSKsort=EXECPU,FCHCPUsort=(exeela,fchela)I really want to get poorly performing queries on the top. and then i want to print 10 top most poorly written queries from t...
42 hours ago5.1 years ago

Hi,I am facing the below exception - ORA-02070: database does not support in this contextHere is the query I am using -INSERT INTO table_1(a,b,c)SELECTtable_name, partition_name, subpartition_name FROM user_subpartitions;Table_1 is in Database_AUSER_SUBPARTI...
42 hours ago4.4 years ago

what is the use of "TEMP_UNDO_ENABLED" in oracle database. when our user also use global temporary table.When it's necessary to set TEMP_UNDO_ENABLED = TRUE in which circumtance?If I enable this parameter to true so it's decrese the performance of database ?...
42 hours ago2.3 years ago

I want to load a jar file into the database. First I loaded it into the root container.loadjava -o -f -noverify -synonym -stdout -verbose -recursivejars -resolve -grant PUBLIC -user sys/password@CDB javax.mail.jar >\mail.logThis also works, but I don't have ac...
42 hours ago6 days ago

Hello Ask-Tom-Team,I came across this Oracle documentation „Deploying Oracle RAC on Docker“:https://www.oracle.com/technetwork/database/options/clustering/rac-ondocker-bp-wp-5458685.pdfSpecifically the sentence:OracleRAC on Docker supports the <b>non-privilege...
42 hours ago6 days ago

We need to code a function to convert database server sysdate to GMT date. So we use: alter database set time_zone='EST' to set dbtimezone, and then code something like:CREATE OR REPLACE FUNCTION FN_GET_GMT_DATE RETURN DATEIS v_dbtimezone varchar2(10);BEGIN ...
5 days ago19 years ago

We are upgrading Apex from 5.2 to 20.2. Our applications are using theme 26. (Of course we need to update the applications to theme 42, but for now this step is too big.)After the upgrade, the prompt of the region buttons is shifted to left (behind the buttons...
5 days ago6 days ago

In some of my custoner´s databases the DBAs are using AUTOEXTENSIBLE datafiles, but with many datafiles comparting the same filesystem, in this sense : tablespace A, datafiles /u01/oradata/ts_A_file01.dbf autoextend unlimited tablespace B, datafiles /u01/ora...
5 days ago8.8 years ago

I am in the process of implementing a process in APEX. This process includes some roles. The process is initiated by a person who fills in forms in the first step.The data entered is stored in collections and entered into the corresponding tables after submiss...
6 days ago13 days ago

Hi Tom,we're making plans to migrate from basicfile to securefile lob storage (Oracle Database 19c). The database also contains some spatial layers, in partitioned tables with a local spatial index. These tables/partitions were defined in Oracle 11 without exp...
6 days ago13 days ago

Hi!We would appreciate your advice about problem we have.We have two tables of the same structure in different DB (DB1 and DB2) . Rows are inserted into table in DB1, and then some of them (based on simple condition) are being prorogated to the table in DB2 ...
6 days ago13 days ago

Hello everyoneAt first, I have an angular UI client and ORDS as API.I'm going to use RAS(real application security) or VPD for row-level security. I read oracle RAS documentation and I didn't catch how to use it with ORDS(without apex) and this is true for us...
6 days ago5 weeks ago

Hello, Ask TOM Team.I have an application (is like a report tool) that reads data from a 18c Oracle Database. One day the results return quick but a couple days after it gets slow. When I execute "ALTER SYSTEM FLUSH SHARED_POOL" command the the results return ...
6 days ago13 days ago

a sql code to remove all the special characters from a particular column of a table .for example :iNPUT-ABC -D.E.FOUTPUT ABC DEFAND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTDONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS....
7 days ago5.2 years ago

We are trying to confirm the expected behavior of Oracle for how it handles sorting on a column where many of the data points are the same value. For example if I queried the following table and sorted on the Data column I might get changing result order on ea...
7 days ago13 days ago