Skip to Main Content

Questions

QuestionUpdatedAsked

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;...
2 days ago3 days ago

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...
2 days ago3 days ago

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...
2 days ago3 days ago

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...
3 days ago20.7 years ago

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 ...
3 days ago6.2 years ago

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 ...
4 days ago13 days ago

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...
4 days ago13 days ago

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 ...
4 days ago21.5 years ago

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 ...
4 days ago6 weeks ago

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...
4 days ago3 weeks ago

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...
6 days ago13 days ago

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...
6 days ago13 days ago

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

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...
6 days ago10 days ago

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?...
10 days ago3.7 years ago

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 ...
11 days ago1.6 years ago

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...
11 days ago18.8 years ago

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...
12 days ago12 days ago

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...
12 days ago4.7 years ago

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 ...
13 days ago2.9 years ago