Skip to Main Content

Can't see the Ask Question button?

Connor and Chris will be back taking questions again soon. Click Notify Me to be emailed when we're back taking new questions.

In the meantime, you can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Questions

QuestionUpdatedAsked

Hello, Ask Tom Team.I want to know to put the correct order in the filter in a SQL query. I mean, in the WHERE condition. 1. How can we help the optimizer in order to have the best performance? I know that it tries to execute the best plan based on the statist...
14 hours ago19 hours ago

I need English only, thanks...
18 hours ago18 hours ago

Hi, TOM!Some time ago I decided to change my unique index to non-unique because of new requirements. I googled a lot but didn't find anything about <b>convertation</b>.Though I found solutions like creating new nnon-unique index with extra constant field in it...
21 hours ago22 hours ago

Hi All, I am creating a table dynamically whose one column name exceeds more than 30 characters.So i am not able to create the table .I tried by keeping the column name within double quotes( " "). But it throw me the same error.is there any way to achieve...
22 hours ago4.5 years ago

Hi,We are storing a 100 digit length number in a varchar2 field in oracle database table column.In PLSQL code, we need to convert this 100 digit number to its binary equivalent (300+ digits), add some more digits to binary and then convert this back to decimal...
26 hours ago3 days ago

hi, we have an oracle apex application running on our LAN, we want to use the same on Android based tabs. I'm a little confused how to go about it as we have no Internet access on our office PCs on which the app is running and same SOP will be applied on Andro...
30 hours ago3 days ago

Hi Tom, I need to replace a word from a String with null from a text field with the following rules.I am trying to frame the rule:So the rule is replace the word TEST with null but if the word TEST is towards the end of the string along with a hyphen - ...
30 hours ago7.2 years ago

I have created a ACL and assigned it to a host. When accessing I get the above erros.I did the following stepsSQL> exec dbms_network_acl_admin.create_acl(acl=>'testlitle.xml', description=> 'all hctra.net connections',principal=>'TAG_OWNER't=>true,privilege=>'...
30 hours ago4.1 years ago

INSTEAD OF triggers are executed instead of DML statements that fired it. Is it correct??...
30 hours ago3.4 years ago

Hello, Ask Tom Team.I would like to know the number of sessions and connections to an Oracle database in a given time.Thanks in advanced....
30 hours ago6 days ago

Hello TOM,I need to use DBCS for implementing Reporting Solution on cloud.Hence need to understand SAAS, IAAS and PAAS platform for cloud.Can you please help me to understand in simple layman terms with examples of all 3.Thanks,Rajneesh...
30 hours ago6 days ago

Tom,What I am trying to accomplish is basically, to monotor any one(mainly DBAs) who connects to the database using "system". I know that, you have advocated to use "audit connect by system" but,I want to have more flexibility (for example, not to audit on spe...
40 hours ago14.5 years ago

Hi Sir,I want to print all out parameters using sql developer and anonymous block. Please refer below scripts.<code>CREATE TABLE EMP(empno number(4,0) not null,ename varchar2(10 byte),job varchar2(9 byte),mgr number(4,0),hiredate date,sal number(7,2),comm numb...
40 hours ago3 days ago

Hello TOM,May I know what we mean by below terms with examples:Data OutagesSiloed DataData AutomationData ProfilingPush Down Data movementThanksRajneesh...
47 hours ago3 days ago

Hello Ask Tom, Team.I am struggling with distributed transactions. Oracle RAC 18c (18.6) and .NET app. I want to know a few things:The RECO background process of an Oracle Database instance automatically resolves failures involving distributed transactions. At...
47 hours ago11 days ago

I tried to create a table learning from with a tutorial<code>create table key_val_pair(id number constraint id_pk primary key,key_val varchar2(100),key_name varchar2(100))segment creation immediate memoptimize for read;</code>it is showing an errorFeature 'Mem...
2 days ago3 days ago

Hi Tom,From my knowledge of oracle, i understand that SELECT FOR UPDATE clause acquires row locks. In that case, if in a given table, when my query updates one set of data, same query should be able to update different set of data by using select for update cl...
2 days ago17.8 years ago

could u please explain the difference between os authentication and database authentication and how it is done, briefly...i have read it but unable to understand it completely(w.r.t oracle 9i) ...
2 days ago15.3 years ago

I have written shell script which connect to Oracle DB (11g) and spool output into excel (.csv / .xls). This works perfectly fine to fetch data in single excel file.I want to enhance my script which will connect to DB and execute 2 different queries which will...
2 days ago2 days ago

I`ve tried to start two Extract. One is started and works. But when I try start one more Extract I get error:<code>2020-04-06T15:27:30.549+0300 ERROR OGG-02615 Oracle GoldenGate Capture for Oracle, e_rf.prm: Login to the database as user GGADMINSRC failed...
2 days ago3 days ago