Skip to Main Content

Questions

QuestionUpdatedAsked

Hello Team,First of all, thanks for all the good work you are doing.Request your help with a query related to re-sequencing of table columns using invisible columns. Is it safe to change order of columns in a production environment, following the method descri...
7 hours ago17 hours ago

Hi Tom,I am given the "current" allocation of items to eight buckets, and I want to make it more efficient by filling as much as possible of bucket A, then of bucket B, then of bucket C (as indicated by the "priority"), by moving items between buckets by takin...
7 hours ago9 days ago

We have a requirement where we are generating .csv file from DB and placed it to a DB directory. We want to zip these .csv files so that size can be optimised. Could you please suggest a way to achieve it by using PL/SQL....
18 hours ago18 hours 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 ...
41 hours ago4 weeks ago

Tom:1. If you want to write something in PL/SQL application server that send email automatically to an administrator requesting approval after a user create a record, which oracle package would be using.Would you also use an after insert trigger for it or jus...
42 hours ago19.3 years ago

Greetings, A question from the client that comes up every few years is to predict if the Oracle database server will be able to handle a new application's peak load. Instead of trying to think of all that needs to be considered on the fly, it would be great i...
42 hours ago8 days ago

Is it possible to change the labels of the confirm dialog buttons from “Cancel/Ok” to “No/Yes” in APEX? ...
42 hours ago9 days ago

Tom,How do you create insert statments dynamically if I give a table name? in TOAD tool, they have this option for each table [Create insert statements] and I was wondering what kind of logic they might have used to create them.I was trying it myself and got s...
3 days ago13.1 years ago

Hai Mr Tam,U said U have a 'trick' for the following problem. It couldbe nice if u tell me that..thanks.A form(5.0) with tabular style is displayed like below..to from discount-- --- -----10 40 1.550 65 2.570 90 1.2. .. .60 ...
3 days ago20.8 years ago

Hi Tom, Chris, Connor and all,I've been a user of your DIY Parallel solution for many years now as a way to pull data out of large unpartitioned tables in parallel to send to other non-Oracle databases or for file system archiving. I've ran into a situation r...
4 days ago9 days ago

How to Select Values, in a Value List, that are NOT IN a Table?e.g. I need to find which of the following products are not on the Item Master:-10, 20, 25, 70, 90. (this list is available only in a spreadsheet or word document)Assume they all exist except 25 &...
4 days ago4.6 years ago

Hello Tom,Please, I need a big help.I have a job scheduled in Enterprise Manager 12c. This job do a full export, but two days ago I started to get the error below:ERROR at line 1:ORA-31626: job does not existORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512...
4 days ago4.3 years ago

May I ask about the "java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver".Per Java document, the PATH and CLASSPATH shall be configured in the Windows 10 environment variables .Below are information regarding the system/database version and what...
4 days ago2 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 ...
4 days ago4 weeks ago

I am using Oracle Cloud Infrastructure (OCI) Autonomous Transaction Processing (ATP) I would like to be able to check for a password's existence in the Have I been pawned compromised password list without loading the file into oracle. (SHA1 encrypt password a ...
4 days ago2 weeks ago

I have a Oracle sql query which needs to be run and need to send the data returned by the query as an attachment to a mail. Could you please guide how can i do it using apex_mail.send procedure. I am calling apex_mail from database. I have already configured a...
7 days ago9 days ago

Dear Tom,We know that when we delete a parent record, automatically child record also will be deleted if we used "on delete cascade".Is it possible to update automatically a child record when we update parent record?(Do we have "On Update Cascade" option? Or a...
7 days ago18.6 years ago

I am trying to use a cte in a query that copies data from one database to another. The cte is used because I am unable to handle a cycle with connect by. In this simple illustration the db link used by the insert causes an error (ORA-00942: table or view does...
7 days ago9 days ago

Hi,I am facing an issue while validating timestamp with timezone data with systimestamp in 11g R2.My DB server is in US/Central zone.I have a table with timestamp with timezone data type column and I have inserted a future timestamp for same timezone (US/Centr...
8 days ago9 days ago

Tom,Thanks for your time.I have two dbs running 11.2.0. I create a DB link named dblk_b from DB_a to DB_b.I have a table by name 'tableB' like below in database DB_b.ID NUMBER(11),CONTENT CLOBI am trying to insert into tableB as followsinsert into tableB@dblk_...
8 days ago4.9 years ago