Query Varie - Cronologia

WikiSysop: /* Per 10.2 */

2026-05-22T13:24:18Z

Per 10.2

2026-05-22T13:23:38Z

Per 10.2

← Versione meno recente		Versione delle 13:23, 22 mag 2026
Riga 435:		Riga 435:
	f.mba,		f.mba,
	f.max,		f.max,
	tsh.used,		tsh.used mballoc,
	tsh.free		tsh.free mbfree
	from tf f		from tf f
	right outer join dba_tablespaces t on (t.tablespace_name=f.tablespace_name)		right outer join dba_tablespaces t on (t.tablespace_name=f.tablespace_name)

2026-05-22T12:30:53Z

Per 10.2

← Versione meno recente		Versione delle 12:30, 22 mag 2026
Riga 429:		Riga 429:
	with		with
	tf as (select tablespace_name,count() nf,round(sum(bytes)/(10241024)) mba,round(sum(case when maxbytes=0 then bytes else maxbytes end)/(1024*1024)) max from dba_temp_files group by tablespace_name),		tf as (select tablespace_name,count() nf,round(sum(bytes)/(10241024)) mba,round(sum(case when maxbytes=0 then bytes else maxbytes end)/(1024*1024)) max from dba_temp_files group by tablespace_name),
	tsh as (select tablespace_name,sum(s.bytes_used)/(10241024) used,sum(s.bytes_free)/(10241024) free from v$temp_space_header group by tablespace_name)		tsh as (select tablespace_name,round(sum(bytes_used)/(10241024)) used,round(sum(bytes_free)/(10241024)) free from v$temp_space_header group by tablespace_name)
	select		select
	t.tablespace_name,		t.tablespace_name,
Riga 527:		Riga 527:

	-->		-->


	==Autoextend datafiles==		==Autoextend datafiles==

2026-05-22T12:29:27Z

Controllo Allocazione Spazio

@@ Riga 425: / Riga 425: @@
 </pre>
-Per 10.2
+==Per 10.2==
 <pre>
 </pre>

2026-05-22T12:28:56Z

Controllo Allocazione Spazio

2026-05-22T11:11:40Z

Job Immediato

← Versione meno recente		Versione delle 11:11, 22 mag 2026
Riga 44:		Riga 44:

	col owner for a15		col owner for a15
	col last_start_date for ~~a42~~		col last_start_date for a30
	col next_run_date for ~~a42~~		col next_run_date for a30
	col start_date for ~~a42~~		col start_date for a30
	alter session set nls_timestamp_tz_format='DD/MM/YYYY HH24:MI:SS.FF ~~TZR~~';		alter session set nls_timestamp_tz_format='DD/MM/YYYY HH24:MI:SS.FF TZH';
	select job_name, owner, enabled, state, LAST_START_DATE, NEXT_RUN_DATE, START_DATE from dba_scheduler_jobs order by 4;		select job_name, owner, enabled, state, failure_count, LAST_START_DATE, NEXT_RUN_DATE, START_DATE from dba_scheduler_jobs order by last_start_date;

	<pre>		<pre>

2026-05-22T11:05:41Z

Job Immediato

@@ Riga 40: / Riga 40: @@
  col owner for a20
  select job_name, owner, enabled from dba_scheduler_jobs;
 <pre>

2026-05-22T10:39:47Z

Job

← Versione meno recente		Versione delle 10:39, 22 mag 2026
Riga 40:		Riga 40:
	col owner for a20		col owner for a20
	select job_name, owner, enabled from dba_scheduler_jobs;		select job_name, owner, enabled from dba_scheduler_jobs;
			select job_name, owner, enabled, LAST_START_DATE, NEXT_RUN_DATE, START_DATE from dba_scheduler_jobs order by 4;

	<pre>		<pre>

2026-05-14T14:08:56Z

Gestione stringhe con caratteri unicode

← Versione meno recente		Versione delle 14:08, 14 mag 2026
Riga 956:		Riga 956:
	---------------------------------------------------------------------------		---------------------------------------------------------------------------
	Fernando, tre caffè! Olé!		Fernando, tre caffè! Olé!

			SQL> select asciistr('èéà°òç½€') from dual;

			ASCIISTR('ÈÉÀ°ÒÇ½€')
			--------------------------------------------------------------------------------
			\00E8\00E9\00E0\00B0\00F2\00E7\00BD\20AC

	SQL>		SQL>

2026-05-14T14:07:24Z

Gestione stringhe con caratteri unicode

← Versione meno recente		Versione delle 14:07, 14 mag 2026
Riga 945:		Riga 945:

	<pre>		<pre>
	SQL> select asciistr('~~Caffé~~ a ~~€1,50~~') from dual;		SQL> select asciistr('Fernando, tre caffè! Olé!') as fernando from dual;

			FERNANDO
	ASCIISTR('CAFFÉA€1,50')
	---------------------------------------------------------------		--------------------------------------------------------------------------------
			Fernando, tre caff\00E8! Ol\00E9!
	Caff\00E9 a \20AC1,50

	SQL> select ~~UNISTR~~('~~Caff\00E9~~ a \~~20AC1,50~~') from dual;		SQL> select unistr('Fernando, tre caff\00E8! Ol\00E9!') as fernando from dual;

			FERNANDO
	UNISTR('CAFF\00E9A\20AC1,50')
	---------------------------------------		---------------------------------------------------------------------------
			Fernando, tre caffè! Olé!
	Caffé a €1,50

	SQL>		SQL>