viniciusmelocodes

SELECT
    CAD.CADASTRO_ID,
    COUNT(*)
FROM
    CADASTROS CAD
GROUP BY
    CAD.CADASTRO_ID
HAVING
    COUNT(*) > 1

viniciusmelocodes

Install OCI8 on Ubuntu 20.04 with PHP 7.4 (Oracle 11G)

Step 1

Download Oracle Instant Client and SDK from Oracle:

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Download files:

viniciusmelocodes

Instalar OCI8 on Ubuntu 21.04 with PHP 8

Paso 1

Descargar Oracle Instant Client and SDK desde Oracle:

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Download files:

viniciusmelocodes

SELECT
	COL.COLUMN_ID,
	COL.OWNER AS SCHEMA_NAME,
	COL.TABLE_NAME,
	COL.COLUMN_NAME,
	COL.DATA_TYPE,
	COL.DATA_LENGTH,
	COL.DATA_PRECISION,
	COL.DATA_SCALE,
	COL.NULLABLE

viniciusmelocodes

CREATE OR ALTER USER FB_ADMIN PASSWORD 'fb_admin' GRANT ADMIN ROLE;

EXECUTE BLOCK
AS
  DECLARE VARIABLE tablename VARCHAR(32);
BEGIN
  FOR SELECT rdb$relation_name
  FROM rdb$relations
  WHERE rdb$view_blr IS NULL
  AND (rdb$system_flag IS NULL OR rdb$system_flag = 0)

viniciusmelocodes

# Guarda data inicial.
dataInicial=$(date)

# Envia notificação para ser mostrado no sistema.
zenity --notification --text "$dataInicial: Iniciando rotina de backup automático para GDrive." 

# Salva texto em arquivo de log.
echo "$dataInicial: Iniciando rotina de backup automático para GDrive." >> /ESTACAO/BANCODADOS/log_gbak_fdb.log

# Gera o arquivo de backup.

viniciusmelocodes

# google-drive-ocamlfuse

$ sudo add-apt-repository ppa:alessandro-strada/ppa

$ sudo apt update && sudo apt install google-drive-ocamlfuse

# To set your Google drive folder, launch the tool.
$ google-drive-ocamlfuse

# It’ll pop up a webpage in your default browser, prompting you to log in to your Google account.

viniciusmelocodes

Salvar em crontab -e:

# Backup do banco de dados TROPICAL.fdb - 12:00 todo dia
0 12 * * * cd /ESTACAO/BANCODADOS && ./backup_banco_dados_tropical.sh

# Backup do banco de dados TROPICAL.fdb - 00:00 todo dia
0 0 * * * cd /ESTACAO/BANCODADOS && ./backup_banco_dados_tropical.sh

viniciusmelocodes

[
  IIF(Length(<MASTER."CNPJ_CPF">) = 11,   
    FormatMaskText('000\.000\.000\-00;0;_', <MASTER."CNPJ_CPF">), 
    FormatMaskText('00\.000\.000\/0000\-00;0;_', <MASTER."CNPJ_CPF">), 
  )  
]

viniciusmelocodes

$path = "D:\trunk"

Get-ChildItem $path -Hidden -Recurse -Filter "__history" | Remove-Item -Force -Verbose -Recurse
Write-Host "Feito: __history"
Write-Host

Get-ChildItem $path -Hidden -Recurse -Filter "__recovery" | Remove-Item -Force -Verbose -Recurse
Write-Host "Feito: __recovery"
Write-Host