Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR ...
47 minutes ago18.5 years ago

Hello, Ask Tom Team.I want to do pagination in a report connected to an Oracle 18c database. I have read there are some methods to do the pagination like: offset and seek. I have several questions1. What method is the best? I have heard that OFFSET methods can...
60 minutes ago1.4 years ago

Hi Tom,We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB.E.g.There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) .I want to run a query from DB A using dblink on DB B to query T1 whi...
25 hours ago15.8 years ago

I have a sqlldr control file that looks like this name char(255) enclosed by '"',contactemail char(255) enclosed by '"',rawtext1 filler enclosed by '"',rawtext2 filler enclosed by '"',auditdate char(255) enclosed by ...
2 days ago4.6 years ago

Hi,I am trying to load a data file into a database table using SQL loader. I received the data in an Excel spreadsheet but I saved it as a comma delimited file.When I run the SQL Loader command no records are loaded - looking at the log file I get the followin...
2 days ago20.2 years ago

I read the article, titled:<b>Event Monitor Process: Architecture and Known Issues (Doc ID 105067.1)</b>…Notification implements a high-watermark scheme where when the backlog of notification events hit an in-memory limit the messages are, in the case of 9.2, ...
3 days ago8 days ago

Hi,I'm trying to consume Oracle fusion rest web service's in PLSQL using apex_web_service. I'm getting the below error. could you please guide me on this.also Pls suggest how to enable the basic authentication in web service like how to set the basic auth.ORA-...
3 days ago9 days ago

Hello!Thanks for answering my questions regarding the testing of Oracle SE2's CPU thread limit on Oracle 11g Standard Edition - I really appreciate the informative response.I have a related question...If we have a server with, say, 18 CPUs hosting 4 SE2 single...
3 days ago1.6 years ago

Dear Tom,about two weeks ago we moved a test database from 12.2.0.1 SE2 to 18c XE via data pump. We used schema import into a pdb with compression enabled (from the parameter file: TRANSFORM=TABLE_COMPRESSION_CLAUSE:"ROW STORE COMPRESS ADVANCED"). There is no ...
3 days ago1.5 years ago

Hi Tom,Just want to ask is there any difference between doing objects(tables,indexes and etc) reorganization within same tablespace and to new tablepsace? Normally i used to do reorganization to another tablespace but this method will need extra space to move ...
3 days ago8 days ago

Hi Tom,Here are the few questions on Locking. 1)How do I use v$lock to figure out lock details ? Details likewhos has locked,on which table,who else is waiting, and what typeof locking (shared or exlusive ?), since when it is locked.2)Why and when exclusive/sh...
6 days ago20.2 years ago

Hi TomWant to understand how and where memory is allocated in an instance to evaluate decode, regexp functions in oracle? If we are reading data from a table and writing it any other location(not oracle), then what would be better-->while firing the query wit...
6 days ago7 days ago

Hello,I am attempting to delete a record / object (that may use several tables at the DB level) from an application.The delete statement is raising aORA-02292: integrity constraint <constraint name> violatedHow can I find the Delete statement (DML) being execu...
6 days ago5.1 years ago

Is there a way to update all listeners to a new OHome after upgrade? Going in manually to each listener (say 10) to update the new OHome seems like there should be an easier way but I'm unable to locate anything on it....
7 days ago9 days ago

a sql code to remove all the special characters from a particular column of a table .for example :iNPUT-ABC -D.E.FOUTPUT ABC DEFAND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTDONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS....
7 days ago5.6 years ago

Experienced this across 3 different instances now. On 19.11.0.0.When IMCS is enabled on a partition which is composite-partitioned. Partition is on a DATE column and SUB-PARTS are on a VARCHAR2 column.IMCS enabled on the latest partition changes the query plan...
7 days ago10 days ago

Tom,I am trying to POST the webservice all using UTL_HTTP function with the file from pl/sql procedures. The same processed working from Curl scripts.PL/SQL :<code>DECLARE req utl_http.req; resp utl_http.resp; l_value VARCHAR2(1024); l_url_import VARCHAR...
7 days ago4.4 years ago

When will Oracle be introducing proper async support into the managed provider?...
8 days ago8 days ago

how to split new line after 30 character and split character with meaning full wordlikeex: 1Split a new line after 30 characterex 1 split character new line but not proper word. I need the result like thisSplit a new line after 30 character...
8 days ago9 days ago

Hi,For below query, i am able to extract the header, but need the lines array in the same sql as json output.DB Version: 12.2.0.1.0<code>SELECT JSON_OBJECT('hdr_id' VALUE hdr_id ,'prno' VALUE prno )FROM XMLTABLE( '/hdr' PASSING XMLT...
8 days ago8 days ago