An Oracle SQLPlus / SQLCL script that generates sql statements then executes them
Here is a easy example of a sql script that generates sql statements and then executes them. Hope it helps. […]
Here is a easy example of a sql script that generates sql statements and then executes them. Hope it helps. […]
Need a very simple way to export Oracle data to CSV format – and import from CSV format? Here is
note: be careful copying the code below from Windows to Unix as a Windows copy may corrupt the single quotes
While many Oracle features are turned on by default, that does not necessarily mean you are using them. If you
12c? Yes, but not for the features Oracle wants you to like. So far anyway, I’m not seeing much use
Here are a few tidbits (not comprehensive – I’ll leave that to Oracle) about “oraInventory”. Generally, it’s directory structure containing
Here is an example of how to run Oracle new command line SQLCI tool – a super sqlplus based on
jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE
define tsname undefine tsname # Put your tablespace name in here define tsname=”%USER%” select df.tablespace_name, fs.GB_FS_BefAuto, df.GB_Tot_Space_BefAuto “Total Space Allocated”,
alter session set nls_date_format=’dd-mon-yy hh24:mi’; SELECT A.*, Round(A.Count#*B.AVG#/1024/1024) HOURLY_Avg_Mb FROM (SELECT To_Char(First_Time,’YYYY-MM-DD HH24′) HOUR, Count(1) Count#, Min(RECID) Min#, Max(RECID) Max# FROM v$log_history GROUP BY To_Char(First_Time,’YYYY-MM-DD HH24′) ORDER BY