Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Tom,I'm looking at a client application which retrieves several columns including ROWID, and later uses ROWID to identify rows it needs to update:update some_table t set col1=value1where t.rowid = :selected_rowidIs it safe to do so?As the table is being mod...
2 days ago16.4 years ago

Hello Tom,I have one column INTERVAL_TIME with datatype as TIMESTAMP(0) and stores data in 15 mins interval time.Since there was DST on 13 March 2016 , the interval was store at 1:45 AM and next interval at 3:00 AM.But when i am applying to_char on the column ...
2 days ago5.3 years ago

Hi Tom – My task: move several dozen text file imports from SQLLDR (on AIX) into callable PL/SQL procedures. The text files are static in structure with daily refreshes of the contents. The contents are loaded into individual tables in our 19c EE database.Th...
2 days ago8 days ago

Hello Sir,Could you give a simple example of running total on emp tableFOr example, running total of sum (sal + comm) department wise?thanks...
2 days ago12.9 years ago

Hi,We have Oracle 12C on 2 instances. I know GV$license can give maximum number of concurrent sessions since start of instances. But is there a way to get maximum we had accessing the database from both together ?Syed...
2 days ago8 days ago

The latest Oracle docs has the following design tip:9.13.5.2 Circular Dependencies Among TypesAvoid creating circular dependencies among types. In other words, do not create situations in which a method of type T returns a type T1, which has a method that retu...
2 days ago8 days ago

The maximum number of cores before needing RAC licensing is per Cluster or for the sum of the Clusters?...
3 days ago3 days ago

I have confusion about explain plan, autotrace and tkprof. When explain plain showing to us the prediction about how optimizer will work to produce result and tkprof show the real thing that happen, so how about autotrace. In autotrace there are two part, as f...
3 days ago15 years ago

Hi Tom, I went through the articles & documentation, your article answers most of the issues Asktom EBR Part 1 => http://www.oracle.com/technetwork/issue-archive/2010/10-jan/o10asktom-172777.htmlAsktom EBR Part 2 => http://www.oracle.com/technetwork/issue-arch...
3 days ago6 years ago

Hi Tom,Good day.Which of this queries is better in performance specially when joining with multiple tables and huge data ?example.1.option 1SELECT h.name, h.je_source, l.entered_dr, l.accounted_drFROM gl_je_headers hINNER JOIN gl_je_lines l ON h.je_header_id =...
3 days ago5.4 years ago

How many autonomous db we could have for ExaCC full Rac?...
3 days ago3 days ago

Is there a way to create a index for a xpath that is including a xpath function?Please consider that xmltype index creation fails at oracle livesql....
4 days ago8 days ago

Hi,<i>Background and Requirement</i> - I am working for a firm that uses <b>Oracle SQL Developer</b> for Data Cleaning and Manipulation of the data residing in the Oracle Database. We use <b>Microsoft Azure</b> for complete lifecycle management and work planni...
4 days ago8 days ago

Hi Tom,I have a query ,I want to pass multiple values to pbd_prod_code is this possible ,as I am getting null v after passing 1001,1002 values to the parameterSELECT field_key, field_lable,FROM json_table( (SELECT PBD_BLOCK_INFO FROM PIIM_PROD_BLOCK_DE...
4 days ago2 years ago

We have a single schema with few 100 objects some of them having millions of rows. The schema have data for various clients. Each client is identified by thier clientid and is a column in almost all the tables. Ex: (will have data of all the clients in the sam...
4 days ago20.4 years 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...
4 days ago20.9 years ago

Hi,I have a column of type <code>TIMESTAMP</code> t in which I safe timestamps with 6 digit precision e.g. 03-FEB-17 04.45.01.909000 PMDue to the way they have ben added to the table they are missing two things:1. The time zone information2. the correct centur...
4 days ago5.3 years ago

Some Days before I have Install Oracle Database New version 12.1.0.2 with no error or warnings.Created 2 pluggable databases in the DB container. <code>SELECT name, open_mode from v$pdbs; NAME OPEN_MODE------------------------------ -...
4 days ago5.7 years ago

Hi Tom and Team,I guess that this issue is related to the namespace, but as I don´t know well this, Could you help meto solve the error running this Select, please?<code>with testTable as ( select xmltype ('<soap:Envelope xmlns:soap="http://schemas.xmlso...
5 days ago8 days ago

Greetings oracle DB gurus,On this subject I want a recommendation, the database weighs 7 teras in total but 5 of that 7 teras is only the audit table, that table only has 3 years of data (The business needs to keep all the data) and it has more than 900 millio...
5 days ago3 weeks ago