Questions

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...

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...

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...

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 ...

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 ...

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...

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...

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...

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 ...

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 ?...

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...

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...

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 ...

Hi Tom,How would you recommend generating PDF documents from within "plain" PL/SQL?Thank you,Dieter...

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 ...

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 ...

Howdy,Just curious what (if any) deleterious effects we would see in the standby databases in an active data guard set up from switching redo logs every 2-3 minutes on the primary?I’m also curious what would be the best diagnostic methods to troubleshoot issue...

Dear Tom,I have 2 tables and I am finding the similarity between the fields using the oracle package: utl_match.jaro_winkler_similarityI am facing the performance issue while accessing the query as a view. I need it as a view because I need to find the similar...

We are using Oracle ATP Database along with Oracle Integration Cloud to implement our integrations with Fusion Apps. We are using a custom schema in ATP database for this purpose. Our schema is configured as following. Properties:Graph - EnabledWeb Access - En...

I have written PL/SQL code to store XML into cursor. Refer the below codeRequirement: As of line at line 83, I am inserting the result into another table (XML_GEN) as XMLTYPE datatype. Line: insert into xml_gen (fxdoc) values (i.FXML); But I don't want to that...