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