LISTAGG Function . SELECT deptno ,LISTAGG(ename, ',') WITHIN GROUP ( ORDER BY ename) AS employees FROM emp GROUP BY deptno; DEPTNO EMPLOYEES -------- --------------- 10 CLARK,KING,MILLER 20 ADAMS,FORD,JONES,SCOTT,SMITH,SMITH 30 ALLEN,ALLEN,BLAKE,JAME...
Setting up transactional Replication in SQL Server PULL Replication Setup on 3 database servers. Where Publisher, Distributor and Subscriber all are in different servers 1) To set up distributor · Go to distributor server · Click on replication folder...
Fixing Missing Rows error in transactional replication Fixing Missing Rows error in transactional replication: · Set up transactional replication http://sqlserverreplicationtroubleshooting.blogspot.com/2011/04/setting-up-transactional-replication-in.html...
Plsql function exception ORA-01403: no data found Cause: No data was found from the objects. Action: There was no data from the objects which may be due to end of fetch Reference: Oracle Documentation ORA-01403 is a very common error. ORA-01403 occurs...
How to return multiple values from a function in Oracle PL/SQL? Generally we write functions for computing some value. Function can return only one value, though it’s definition may contains more than one return statements. This article explains us how...
Autonomous Transaction in oracle An autonomous transaction is an independent transaction started by another transaction called as main transaction. It let you allow to execute various DML statements, commit and rollback without commiting or rolling back...
Backup's =========== full:: backup database dbname to disk='path' Differential:: backup database dbname to disk='path'with differential log:: backup log dbname to disk='path' mirror:: backup database dbname to disk='path' mirror backup database dbname...
Frequently you want to know how fast your database has been growing. Based on the backup history we can get a rough outline of the growth of a database, over time, from the msdb..backupset table. This query will give the size of the backup, every time...
