Questions

Hello everyone, I ask for help to solve a problem with the pivot and unpivot functions. is it possible to merge numbers with text? in the result I would like to add the row of the column ects_cod. Thank you<code>CDS_COD;VALORE;31;30;29;28;27;26;25;24;23;22;21;...

Dear Asktom team,We are processing external tables, where it is agreed that the incoming files are in character set EE8SSWIN1250.Nevertheless, it may happen that the incoming file has a different character set. The file is processed, but the characters are scr...

Hi TOM,i have been working with single tenant database from the start 8i upto Database version 11.2 , now i need to work with multitenant database 12c and above. i have installed 19c database, but i am having difficulty moving around (login etc)Can you point s...

Hi Tom,can u tell me that how can i scheduled my procedures execution. for example there is a procedure namely 'abc' i want to execute it at 4'o clock every day. it would by highly appreciated if u provide my any code, or reffer documents etc. in this regard.p...

Hi Tom,I am not able to understand one thing, I have two test databases, and separate hardware. It is a Server class installation and Enterprise addition, with all default optimizer settings. In one database say db1, when I am running dbms sqltune advisory it ...

Hi,I have a nested table with three columns within the nested column. I have 3 entries for the same ID within the nested column. I want to unnest this table and get the 3 entries as separate columns in single row. How do I do it?Below is the code:<code>create ...

Hello Tom,Is there a way to find out the maximum SGA and PGA ever used in an instance ?We need to do some strict assessment where we need to check whether the SGA and PGA assigned by us is being completely utilised or not. If not 100% utilised then how to find...

Tom,Would you tell me what snapshot too old error. When does it happen? What's the possible causes? How to fix it?Thank you very much.Jane ...

Team,Given this JSON, how do i increment the quantity by two in each level?tried the below using json_transform but ended up with error.is that possible using json_transform function? kinldy help.<code>demo@XEPDB1> select json_serialize(y pretty) y 2 from t ...

Hey Connor :-),I've seen this pretty nice graph about "Active Sessions Per Activity Class" from EMCC 13.5, take a looking at the following 2 number of screenshots.https://quanwenzhao.files.wordpress.com/2021/11/active-sessions-per-activity-class_1.pnghttps://q...

Hi, I support a comparatively small project of around twenty OLTP instances on AWS. My customer expects both full auditing and least necessary privileges in all environments -- which hasn't been a problem for code development and artifact promotion. My team le...

Hello,Any advice or suggestion on what tool or software (3rd party) i can use to replace BMC fast unload? i have several scripts running using it but with upgrade in oracle, sometimes i am having problem with the software (compatibility i guess). i learned tha...

What info fo weather forecasters have that make them not agree with the computer models? ...

Hello, I am studying and analyzing Oracle Redo Logs. They have a pattern for each DML such as OP 5.1/ OP 11.2 for INSERT Statement. Few days ago, I found new OP Code that I have not seen before, which is OP 11.22 and 11.28.Unfortunately, the only information a...

I have query like:<code>select case when 1 in (1,2,3) then(select 'abc' as "name 1",'xyz' as "name 2" from dual)else 'pqr' end from dual; </code>How can I return two columns if a condition is satisfied in case?...

Before understand question mind I have one table with 3 columns one is id second is description and third is sql query, i created one Apex page with two region one is static region and one is Interactive Report Region. In Static region i have one select list ...

Hi Tom,I tried to use Bind Variables in my Script. But that script is taking more time than expected. Please have a look at the below script.area@DBWH> truncate table t1;Table truncated.Elapsed: 00:00:00.50area@DBWH> declare 2 begin 3 for i in 1..100000...

The following question was asked, but got attached to the Nov 24th session which was re-scheduled to this Nov 18th session:Question from USER399341 forDatabase In-Memory Office Hours - 2021-11-24I have a Table with all transaction amounts (both +ve and -ve amo...

Hello ,i want to have multiple value per cell and i used nested tables.After creating my table projects with a the nested column categories, i insert some rows. but when i do select * from tables , i have the error unsupported data type by the column categorie...

Hi Tom/Team,I have installed Oracle 11g Database on my Windows 10 64-bit machine.All installation has been completed successfully. I have checked connections by sqlplus and it's running fine. I am able to run queries as well there. So database is working fine ...