Skip to Main Content

Questions

QuestionAsked

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...
--17 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...
--9 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....
--19 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 ...
--4 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...
--19.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...
--8 days ago

Is it possible to change the labels of the confirm dialog buttons from “Cancel/Ok” to “No/Yes” in APEX? ...
--9 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...
--13.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 ...
--20.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...
--9 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.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.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...
--2 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 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 ...
--2 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...
--9 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...
--18.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...
--9 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...
--9 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_...
--4.9 years ago