Skip to Main Content

Questions

QuestionUpdatedAsked

I am in the process of implementing a process in APEX. This process includes some roles. The process is initiated by a person who fills in forms in the first step.The data entered is stored in collections and entered into the corresponding tables after submiss...
13 hours ago7 days ago

Hi Tom,we're making plans to migrate from basicfile to securefile lob storage (Oracle Database 19c). The database also contains some spatial layers, in partitioned tables with a local spatial index. These tables/partitions were defined in Oracle 11 without exp...
19 hours ago7 days ago

Hi!We would appreciate your advice about problem we have.We have two tables of the same structure in different DB (DB1 and DB2) . Rows are inserted into table in DB1, and then some of them (based on simple condition) are being prorogated to the table in DB2 ...
19 hours ago7 days ago

Hello everyoneAt first, I have an angular UI client and ORDS as API.I'm going to use RAS(real application security) or VPD for row-level security. I read oracle RAS documentation and I didn't catch how to use it with ORDS(without apex) and this is true for us...
19 hours ago5 weeks ago

Hello, Ask TOM Team.I have an application (is like a report tool) that reads data from a 18c Oracle Database. One day the results return quick but a couple days after it gets slow. When I execute "ALTER SYSTEM FLUSH SHARED_POOL" command the the results return ...
20 hours ago7 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....
30 hours ago5.1 years ago

We are trying to confirm the expected behavior of Oracle for how it handles sorting on a column where many of the data points are the same value. For example if I queried the following table and sorted on the Data column I might get changing result order on ea...
33 hours ago7 days ago

Hi Sir,I have a csv (Say Dummy.csv) file like the below :<i>"D_ID","D_DATA_A","D_DATA_B""1","Normal Data","This is a Dummy Data""2","Data with Comma","This is a Dummy Data, with Comma""3","Data with New Line","This is a Dummy DataAlong with New Line""4","Data ...
33 hours ago7 days ago

Hello. I have a query that produces a result. We need to automate the result into a text file with pipe (|) delimited characters that will be used in another process. The problem is that creating this file using the UTL_FILE tool will store it on the databas...
2 days ago7 days ago

Tom, I have a few questions related to autoextends:1. Can you tell me the advantage and/or disadvantage of having "autoextend on" for every datafile I create in the database? 2. If I have a tablespace with all datafiles created to have autoextend on, then I t...
2 days ago18.3 years ago

Hi TomI have installed SAP on Oracle DB there is one table space PSAPSR3 got created & we have only 1 sapdata FS like /Oracle/FS/sapdata.So can you help me how auto extend will work , will it extend all table space if we set auto extend?Thanks,Nitin...
2 days ago2 weeks ago

Hi Any idea on what is a #hash view and creating triggers on #hash view? If you know please leave a script/query for the same.Schema Consolidation:There multiple schemas, For ex:Schema1Schema2Schema3Schema4Now i want to move all the objects & data of schema2, ...
2 days ago2 weeks ago

Hello,rather basic question. Does database guarantee to return rows from external table, OS file, in the same order as they are positioned in file.I am well aware that only proper order by clause can achieve this. But we have some 10+ years old database job wh...
2 days ago2 weeks ago

Hi,Can we merge multiple PDF documents into 1 PDF using plsql function?If so please suggest me the solution.Thank You,Vidya KBangalore...
2 days ago1.6 years ago

Hi Tom,Can you explain, what is 'EDITION' and what is it meant as cross-edition triggers? How it can be useful for high availability.Thanks for you replies. It is a big learning experience....
2 days ago11.5 years ago

I was wondering if there is some possible way that I can fetch the last record from a table. In this particular case, obviously one is unaware of the number of records in a table. All I want is to write a query whcih will simply fetch all the columns of the la...
2 days ago19.8 years ago

Hi,Thank you for reviewing my question. Two nodes RAC database version 11.2.0.41. Query is generated at the application server2. Persistent connection to the database using the same account 3. The query is using a lot of IO. When there is more than 40 ex...
2 days ago1.8 years ago

Tom,I am little confused about Oracle Database and instances. If I have created a database DB1, and started it,open for all users, does it mean it is one instance? How can I have multiple instances of a database and how do I find what Instance I am using?So, ...
2 days ago12 years ago

Hi Tom,I am trying to extract multiple hostname out from a long strings (In fact, I will use this method for DBLink - host column later). However, my query is only able to extract the first hostname. I did try to put {1,0} after the match pattern '((HOST|HOST...
7 days ago7 days ago

Hello Tom,Supposed my data file got crashed at 9PM IST & we to do point in time recovery.We have a full db backup which was started at 8AM IST & got finished at 7PM IST in that do we need to apply redo log archive backup?Can you tell me how will come to know w...
7 days ago7 days ago