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

Hi Tom,I have a table like thiscreate table temp1(f_name varchar2(100), f_date date, f_amount integer);Records in this table will be like this:Ajay 15-JUL-02 500Bhavani 15-JUL-02 700Chakri 17-JUL-02 200Ajay ...
9 hours ago18.5 years ago

It is probably apparent from my job title that my role is far from a dba. I am, however, a frequent user of Oracle SQL Developer. I work in mass appraisal and use SQL Developer to select, update, insert, delete, etc., on a regular basis. I would like to bring...
9 hours ago2 days ago

The following shows that the same (JSON) table data and the same queries yield different results when different NLS_NUMERIC_CHARACTERS are used.The above sentence is no surprise, obviously, but in this case I consider the behavior to be wrong; Please explain w...
9 hours ago4.4 years ago

Hello,I have a production problem for which I need your inputs.Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production1) There is a monthly Partitioned Oracle table with monthly Partitions created at during table creation.2) The a...
9 hours ago2 days ago

Hello Chris, Hello Connor.I know that hash join performance might suffer a lot if it has to store the hash table on a disk, but I have no idea how to check if that's happening and that is the reason a query is slow.Admittedly I do not know much about memory us...
29 hours ago2 days ago

Hi Tom and Team,I have a very simple table with the following records.site_no,sku_no,vendor_id,ven_typeA sku_no can have multiple vendor_id values associated to it. A vendor_id can have a ven_type = P (Primary) or S (Secondary)I want to find all those sku_no v...
30 hours ago2 days ago

Dear Tom,I'm trying to connect my pdb - pdb1, using tnsnames.ora. I have granted tom dba privs just for testing purpose. My database name/CDB name - TESTMy pdb name - pdb1<code>sqlplus tom/tom@pdb1ERROR:ORA-01017: invalid username/password; logon denied</code...
35 hours ago4 months ago

Hi Tom,We are dealing with a system which has some legacy tables with LONG column. One of these tables contains critical data (email bodies and attachments, chat transcripts, etc) in LONG column. Unfortunately we cannot remove or even change this table in any ...
2 days ago4 days ago

Hello, AskTom!Excuse me for the "idle" question, but none of my colleagues could answer this.Many-many years ago, back in Oracle 7, was a "constraining error" ORA-04094 "Table is constraining, trigger may not modify it".This restriction was relaxed since Oracl...
2 days ago4 days ago

We have batch_table with column batch_id having values 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.Running sample code for demonstration.<code>PACKAGE XXXPROCEDURE YYYISvariables... BEGIN FOR i IN (SELECT batch_id FROM batch_table) LOOP -- Function call IF get_running_thr...
2 days ago4 days ago

I have a oracle 12c installation.Following commands were executed as SYS user.ALTER SYSTEM SET MEMORY_MAX_TARGET=20G SCOPE=SPFILE;ALTER SYSTEM SET MEMORY_TARGET = 20G SCOPE = SPFILE;ALTER SYSTEM SET PGA_AGGREGATE_LIMIT = 15G SCOPE = SPFILE;ALTER SYSTEM SET PGA...
2 days ago3.8 years ago

Hi Tom,I have a table and 2 or more after insert/after delete triggersCan you tell me what will be the order of firing after insert triggers.I have 2-3 after insert triggers on the same table.I have tried by finding this using timestamps but all have the same ...
2 days ago15.2 years ago

Hi all,I am having a struggle with a view. The outcome of the view can be 1 row of 3 different views with the same fields.Can someone point me in the right direction how to think please? :)Very basic, this is my problem:<code>/* MAINVIEW */SELECT * FROM (SELEC...
2 days ago4 days ago

Hi,I have a sequence name s1 start with 1 and incremented by 1 and end with 999.I am inserting these sequence value into one table name 'e'. E table contains eno (pk) column. insert into e values(s1.nextval); I inserted 9 rows. sequence current value is 9 and ...
3 days ago4 days ago

Hi,how to create view with parameter?we want to create view definition as below,<code>create view test_item_vas select item_class,nvl(rev_id,v_rev_id),sum(total_cost),sum(total_resale),sum(margin)from test_item_classwhere rev_id = v_rev_id;</code>Please sugges...
3 days ago3.5 years ago

Hi, I'm try to evaluate the Json query. e.g I have following json string in the table<code>{ "WO": [ { "id": "1", "name": "WO1", "action": "add", "items": [ { "id": "1", "author": "Tom Ask" ...
3 days ago4 days ago

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...
3 days ago4.4 years ago

Greetings,I've seen when "cpu_per_call" limit is reached. ORA-02393 is sent to the SQL Plus. Is there a view that a DBA can query to find out if "ORA-02393: exceeded call limit on CPU usage" occurs to applications using the database since it isn't written to...
3 days ago8 days ago

Hello,I have a problem with <b>Real-time Materialized View ‘ON QUERY COMPUTATION’</b> functionality.My Real-time MV is enabled for both <b>QUERY REWRITE & ON QUERY COMPUTATION</b>.As I understand, when the MV is fresh, we get a MAT_VIEW REWRITE ACCESS FULL run...
3 days ago3.8 years ago

Environment: Oracle 18XE 64-bit for Windows.I have a question about dequeueing an array of messages from persistent queue.It’s a simple point-to-point messaging. Queue is “single_consumer”, without propagation.I registered my PL/SQL callback function. I need t...
4 days ago9 days ago