We have an application in Oracle APEX where we do not have a large database and the number of pages used in the application would be max 250. However, there is a 500 Internal Server error that we are encountering since the last 3-4 days and we have not made an... | 34 hours ago | 3.5 years 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(... | 34 hours ago | 10 months ago |
Hi Tom,What plan do you suggest to purge a table which is of size 377Gb approx?We are currently following this plan,- Creating a temporary table with the required data(Approx 86 crore records).- Drop the constraints(15 constraints).- Truncate the original tabl... | 2 days ago | 1.1 years ago |
In Oracle SQL Developer, 'Application Express' section, we can export DDL for an APEX app by context menu, 'Quick DDL' > 'Save to Worksheet' menu. I'd like to do the same by executing some SQL or PL/SQL code. I know we have DBMS_METADATA.GET_DDL, but that does... | 3 days ago | 4.6 years ago |
Hi,I discovered the powerful, not officially documented, hint OPT_ESTIMATE about 12 years ago. Recently I discovered the following officiel document about it:Oracle Support Document 2402821.1 (How To Use Optimizer Hints To Specify Cardinality For Join Operatio... | 2 weeks ago | 3 weeks ago |
Hello,I'd like to write a query based on dba_source/all_identifiers/all_dependencies to find all the queries/cursors that have more than x joins involved. Can you help me ?RegardsHans... | 2 weeks ago | 3 weeks ago |
Hi,Could you please have a look at below table structure<code>drop table child purge/drop table parent purge/create table parent (id number(11,0) ,dt date ,constraint pk_parent primary key (id))partition by range (dt) (par... | 2 weeks ago | 3 years ago |
Hi Tom,In one of the interview, interviewer asked me about the scenario where bitmap index is useful in OLTP system.and I was totally clueless.....I wasn't able to think any of the scenario.Later I googled every possible combination to get some info about the ... | 2 weeks ago | 6.5 years ago |
I would like to know your advice about migrating a database from WE8ISO8859P15 to AL32UTF8. We have a DB running WE8ISO8859P15 properly with a lot of applications, but a client suggests that it would be a good idea to change it so it is the same in their Java ... | 2 weeks ago | 2 weeks ago |
We have a unique auditing requirement where we want to know all updates to the system by a 5 digit terminal no for a given time period. Each user input coming through the legacy network always has an associated 5 digit terminal no. This user input will be proc... | 2 weeks ago | 18.8 years ago |
Hi,In below article https://oracle.readthedocs.io/en/latest/sql/basics/query-processing-order.htmlIt is written that the order in which clauses are logically processed by Oracle is as follows: FROM -> CONNECT BY -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDE... | 2 weeks ago | 3 weeks ago |
Hi All,I am a new developer to Oracle SQL and PL/SQL. I have the below scenario, if you could please help me find the most optimal solution for this I would be very grateful. If there is any other thread already which shows the solution to similar scenario pl... | 2 weeks ago | 4 weeks ago |
We have report grids showing 2 or more (maybe 6) columns of "Who" did what.To fetch and show their real name based on username:Is it better performance to have a subquery for each "Who" column or just return the username in the query column, andin that column ... | 2 weeks ago | 3 weeks ago |
Respected sir/Memi am new in oracle database with apexcan you please help me i want to insert data into table with Where clause, is it possible in oracle ?... | 2 weeks ago | 3 weeks ago |
Hi, When I start the ords server file I am getting following error (ORA-12514) TNS:Listner does not currently know of service requested in connect descriptor.I have tried connecting using SQL PLUS as sys SQL> conn/ as sysdbaConnected to an idle instance.SQL> s... | 2 weeks ago | 3 weeks ago |
connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist... | 2 weeks ago | 7.1 years ago |
Hello Tom,I have very silly question for an experience person in oracle. but i am totally confused. please helpAs per my knowledge, memory_target is the parameter which oracle use to tune sga and pga components. and Memory_max_target is the parameter which is ... | 2 weeks ago | 7.1 years ago |
Hi Tom,How would you recommend generating PDF documents from within "plain" PL/SQL?Thank you,Dieter... | 2 weeks ago | 14.7 years ago |
Hello,The below query does not return any value when the value of the counter is equal or greater than 110000000.NOTE: It works well for 6100 or 19 000 000 as example.<code>select to_char(to_number(counter))from(select level counter from dual connect by level ... | 3 weeks ago | 3 weeks ago |
Hi Experts,I am fairly new to Oracle Apex. My req was basically to make a OCI instance with a program which lets me upload files to it. I was able to succesfully do that, but then i needed to make a Simple UI. I was asked to use oracle Apex for that. Thinking ... | 3 weeks ago | 3 weeks ago |