Skip to Main Content

Questions

QuestionUpdatedAsked

<b></b>Team,let us consider our normal scott schema for this concern.Let us consider emp table.REM INSERTING into empSET DEFINE OFF;Insert into emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_date('17-12-80 00:00:00','DD-...
15 hours ago4 days ago

I tried to install Oracle XE 18c,but it keeps rolling back. On trace log, it said no valid ip address return for the host. I'm using windows 10 pro. What should i do to fix this problem? ...
15 hours ago4 days ago

Hi Tom,Is that we can changed the unified audit log tablespace from SYSAUX to standalone tablespace(example: TBS_AUDIT) online without restart the database? If yes, is that will be any impact by doing so?...
15 hours ago4 days ago

Team,This is is continuation with the below link :https://asktom.oracle.com/pls/apex/f?p=100:12::::RP:P12_QUESTION_ID,P12_PREV_PAGE:9543884800346428497,11I could not continue on that link , so sorry to raise a new request.The solution provided there works wel...
15 hours ago3 weeks ago

Dear Tom,I'm wondering about how a 'cancel' in Oracle works.For example, I have a long running query and I define a timeout on application level.Once the timeout is reached, the application sends a 'cancel'.What i observed is, that the cancel does not seem to ...
15 hours ago3.4 years ago

I'm playing around with Oracle 12c and trying out the new features. One of the new features is that the WITH clause in a SQL query now allows for a PL/SQL function.I created the following sample query:<code>WITH FUNCTION get_number RETURN NUMBER IS BEGI...
15 hours ago3.9 years ago

HiThough I have checked in google many times for the answer of my question 'Write PLSQL procedure to get query result in an excel automatically', till I am not having clear understanding .Could you Please explain it in simplest way possible.(like creating 1/2...
15 hours ago3.4 years ago

Can we add a new column between two columns.If yes,please tell me command...
15 hours ago6.1 years ago

Hi Tom,I am trying to convert a non partitioned table into interval partitioned table online.I created a simple test table and ran the below script but I get ORA-14006 invalid partition name error. My conjecture would be this is not allowed for interval partit...
15 hours ago4.6 years ago

Hi,i want to export only the objects owned by given schema using EXPDP, but unfortunately it is exporting all the objects which schema has access to.i am using below syntax.<code>expdp school/school@orcl schemas=(demo) directory=DATA_PUMP_DIR dumpfile=demo.dmp...
15 hours ago13 days ago

Tom,what does this "HYBRID TSM/HWMB" in the below plan indicates? I see this in 12.1.0.2<code>rajesh@PDB1> explain plan for 2 insert /*+ enable_parallel_dml parallel(t1) */ into t1 3 select /*+ parallel(t) */ * from t ;Explained.rajesh@PDB1>rajesh@PD...
15 hours ago6.1 years ago

Tom:I have a question regarding index. can you explain me in detailwhat the following means.If the index is a concatenation of multiple columns and oneof the columns contains a NULL value, the row will be in the index column containing the NULL value and will ...
4 days ago21.2 years ago

Hi Ask Tom Team,I have a requirement to load JSON file into a table in Oracle database. Have seen some examples using External Table and filling it from a JSON File & then extracting fields through JSON functions to load data into relational table. Need your s...
4 days ago4.7 years ago

Hello,I have written a stored procedure to truncate the multiple tables. When running the procedure no error but when checking by select statement still I can see that in the table. This means the procedure is not doing anything. Any help much appreciated. Wha...
4 days ago1.6 years ago

Hi Tom,I am not able to fully understand below recursive query. Especially, the condition "WHERE POS > 0" and " WHERE POS = 0". my understanding is pos is result of REGEXP_INSTR (STR, '[A-Z][0-9]{5}',1, RN). 1. if the first POS > 0, how could the final conditi...
4 days ago13 days ago

HiWe have an application written with PL/SQL and thus with commit point optimization. However AWR reports show a lot of log file sync waits. How do autonomous transactions, which we are using for logging purposes operate with pl/sql code. Is the commit point o...
4 days ago13 days ago

Please can I get the zoom link for today's conference?...
4 days ago5 days ago

Hello Tom, I would like to be able to roll up a word count (for a WordCloud control in a UI) based on a query ( a spatial query in this case).I have a table as such<code>create table items (id raw(16), text clob, geom sdo_geometry )</code>This table has a full...
5 days ago4 years ago

As you know, the association between an SCN and a timestamp when the SCN is generated is remembered by the database for a limited time period and an error is returned if the SCN specified for the argument to SCN_TO_TIMESTAMP is too old.Example:<code>select scn...
5 days ago13 days ago

Dear Ask TOM Team,Thank you for your appreciated efforts and providing the guidance to all concerned clients.My question:I have running and in production oracle DB, 11g ... and would like to import and update the data from other DB with the same structure and ...
5 days ago13 days ago