SQL Server Window FunctionsSQL Server Window Functions
SQL Server Window Functions calculate an aggregate valu […]
年度归档： 2021 年
Oracle DENSE_RANKOracle DENSE_RANK
Introduction to Oracle DENSE_RANK() function The DENSE_ […]
SQL Server DENSE_RANK FunctionSQL Server DENSE_RANK Function
Introduction to SQL Server DENSE_RANK() function The DE […]
Recover Database until cancelRecover Database until cancel
Is it necessary to perform “recover database unti […]
Python send emailPython send email
crontab: 30 06 * * Mon /home/ted/send_email.x > send […]
How to Enable RMAN block change tracking for a physical standby databaseHow to Enable RMAN block change tracking for a physical standby database
Enabling Block Change Tracking on a Physical Standby Da […]
Amazon S3 EncryptionAmazon S3 Encryption
Oct 22, 2019 2:07:24 AMPosted by Aviv Degani, Cloud Sol […]
Check long running DML progressCheck long running DML progress
select SQL_ID, OPNAME, SOFAR, TOTALWORK, START_TIME, EL […]
datapump with querydatapump with query
Create DIR: CREATE [OR REPLACE] DIRECTORY directory_nam […]
How to create db-linkHow to create db-link
Task: In Database A, create a db-link connected to Data […]