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 ago | 2 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 ago | 7 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 ago | 7 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 ago | 3 days ago |
How can I reduce CPU utilization of Oracle database? ... | 11 hours ago | 22.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 ago | 22.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 ago | 7.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 ago | 22.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 ago | 2 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 ago | 2.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 ago | 5 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 ago | 2 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 ago | 8 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 ago | 4.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 ago | 7 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 ago | 4.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 ago | 2 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 ago | 7 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 ago | 6.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 ago | 22.4 years ago |