Defination : Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies...
SQL*Loader : bad file vs discard file What is the difference between the bad file and the discard file in SQL*Loader. The bad file and discard files both contain rejected rows, but they are rejected for different reasons: Bad file: The bad file contains...
How to display even records in a table? SELECT * FROM emp WHERE (rowid,0) IN (SELECT rowid, mod(rownum,2) FROM emp );
How to print the even and odd numbers from 1 to 10? BEGIN FOR i IN 1..10 LOOP IF mod(i,2) = 0 THEN dbms_output.put_line(i||' is an even number'); END IF; END LOOP; FOR i IN 1..10 LOOP IF mod(i,2)!= 0 THEN dbms_output.put_line(i||' is an odd number');...
Difference Between Cursor And Ref Cursor In this post I am trying to detail out the differences between Cursor and Ref Cursors. I am sure, this question has been asked in many interviews to many of us and it also has its own technical weightage. Lets...
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...
