Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Team,I use ApEx 22.1 and SQL Developer.In an ApEx page, users have to upload 4 photos of their workstation. Then with PL/PDF I generate the PDF containing texts, photos and ID number.I have no control over the uploaded photos. The aspect ratio of the images...
10 hours ago2 days ago

Hi ASKTOM team, I'm a beginner of APEX. In our system we have many differents DBs (different hosts) but they have same table structures. If user A choose in a DB-list DB1 and logged in, APEX server will connect to DB1 and uses all data from DB1If user B choose...
10 hours ago7 days ago

Greetings,In this version SQL developer 23.x, when clicking on the "+" sign next to the database, it disappears, and the database does not open.However, in older versions like version 19, the database opens normally.I have tried many versions of Java, but the ...
10 hours ago7 days ago

Hi!, What is the best way to defragment SYS.AUD$? It is possible to use DBMS_REDEFINITION.REDEF_TABLE ?Thank you in advance....
10 hours ago3 days ago

How can I reduce CPU utilization of Oracle database? ...
11 hours ago22.2 years ago

Hello Sir Is there any view avaiable through which we can know from which file our instance has started.Is it pfile or spfile.Without making any changes to file and then seeing it by opening it.Thanks ...
11 hours ago22.2 years ago

Hi,I am carrying out an update on dept table with update query as - "update dept set dname = initcap(dname) where deptno=20;"As, I have not committed, row lock will be placed on the row. I want to find out the rowid of dept table locked from V$LOCK. Currently,...
11 hours ago7.9 years ago

TomI've been re-visiting my knowledge on NOLOGGING as a colleague asked me a question about it today and I hate to say I couldn't remember fully why the term is a tiny bit of a misnomer (there's no denying that there is a general confusion "out there" about NO...
11 hours ago22.4 years ago

We have a context index that is SYNCing every 6 seconds. Here is the DDL for the index: CREATE INDEX "SSS"."QUOTE_NUMBER_CONTEXT" ON "SSS"."QUOTE" ("NUMBER_") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('SYNC (EVERY "SYSDATE+1/14400")');This was working p...
11 hours ago2 weeks ago

While we are working on dbms_cloud API in ATP DB, we are facing some issues. When we are calling the API directly from SQL Developer, it works perfectly fine and data is getting loaded into the tables.<code>BEGIN dbms_output.put_line('Start Time : '||TO_CHAR(...
19 hours ago2.2 years ago

It took me a while pick database development over dabase administration, concerning a editions.My questions is simple, if I've decided to create an editioning view over a table with N triggres, what would I do about this??some people says all triggers must be ...
23 hours ago5 months ago

The following is a simplified version that exhibits the behavior in question.There are two tables T and F.1% of the rows of table T are indexed by T_IX.Though F has the same number of rows as T_IX, F has 1% of rows "in common" with T_IX.The cardinality are as ...
44 hours ago2 days ago

I activated audit on some just for unsuccessful connection attempts ( my purpose was finding who/what locks some users ).This is something I had already done many times, always fine.However on a 19 version I noted something I could not find an explanation for:...
2 days ago8 days ago

Trying to deal with timezone + DST aware datetime handling, but I couldn't get it safe and convenient at the same time.The almost perfect solution would be timestamp with local time zone , except the fact that it uses nls_timestamp_format (opposed to using nl...
2 days ago4.6 years ago

Hello, As far as I understand it, Oracle processes regular expressions according to the POSIX standard, but also supports expressions that originate from Perl.Currently I had some missleading results when searching for a space. Theoretically, this should be fo...
2 days ago7 days ago

Dear Sir,Hope doing well..Need some clarification on below points.1) What is fastest way to change DB_BLOCK_SIZE from 8k to 16k, my DB size is 2TB.2)Can we duplicate database as active database from standby database and snapshot database.Please comment on this...
6 days ago4.5 years ago

Hi,Recently while preparing to run the Release Upgrade for 19.24 I was doing a cold back of my ORACLE_HOME and I noticed that I had a ton of old .log, .trc, and .trm files. I deleted old files in the trace directory, audit directory, and some of the log direc...
6 days ago2 weeks ago

Dear Experts,Need your guidance/suggestions to resolve this issue:Part of oracle advance queueing implementation, we've to dequeue the message as soon as it has been enqueued into the queue. This should happen immediately without any manual intervention/schedu...
6 days ago7 years ago

Hi,I would like to know IP Address of DB Server.So i executed below Query found on Google.SELECT A.HOST_NAME,A.INSTANCE_NAME,UTL_INADDR.GET_HOST_ADDRESS FROM V$INSTANCE A;I got one IP Address but its not matching with the IP address in TNS?So i would like to ...
6 days ago6.8 years ago

Hello Tom,I have a live table (Investor) with customers records and another table (Invdatew) has the same records but have one extra column for date,. After each end of day I use dbms_job to insert the the exact data from live table to the other one plus sysda...
6 days ago22.4 years ago