Archive for Januar, 2019

m.Doc – der Arzt ist immer mit dabei

Dienstag, Januar 1st, 2019

SQL Tutorial – the SQL cheat sheet provides you with the most commonly used SQL statements for your reference

Dienstag, Januar 1st, 2019

SQL Tutorial – helps you get started with SQL quickly and effectively through many practical examples

Dienstag, Januar 1st, 2019

If you are a software developer, database administrator, data analyst, or data scientist who wants to use SQL to analyze data this SQL Tutorial is a great start

SQL Tutorial – MINUS query giving results on exactly same data in two tables

Dienstag, Januar 1st, 2019

Oracle Database – total size of the database

Dienstag, Januar 1st, 2019

Oracle Database – consists of data files, redo log files, control files, temporary files and the size of the database actually means the total size of all these files

select
( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +
( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +
( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) „Size in GB“
from
dual