This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . Analytic functions in oracle We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO” …
How to use Analytic functions in oracle (Over Partition by Keyword) Read More »
Oracle Clusterware is the Clusterware technology from oracle to Manage the Oracle RAC database on various platforms. Oracle has provided cluster utilities to manage it. Here are some of the useful oracle Cluster commands(oracle RAC commands) in 10g,11g, and 12c CRSCTL command Cluster Control utility performs the various administrative operations of Oracle Clusterware. It is …
Useful Cluster command in Oracle clusterware 10g , 11g and 12c Read More »
In this post, we will learn about sql loader in oracle, SQL loader syntax in oracle, SQL loader direct path load, SQL loader examples Sql Loader in Oracle This tool is used to move the data from Non –oracle standard source or external files into the oracle we can Load data from multiple data files …
ORA-00934 group function is not allowed here is one of the common messages we often get while aggregating data. Causes of ORA-00934 group function is not allowed here This error happens when you are trying to use the where clause to restrict groups CREATE TABLE “EMP_DATA” ( “EMP_NO” NUMBER(4,0), “EMP_NAME” VARCHAR2(10), “JOB” VARCHAR2(9), “MGR” NUMBER(4,0), …
ORA-00979 is a common error which is associated with invalid usage of the group by clause. Here is the oerr output for this error Causes of ORA-00979 not a group by expression This error happens when you are using a mixture of individual columns and group functions in the same select statement while missing the …
ORA-03113 is quite a common error. Let us take a deep dive into it Issue ORA-03113: end-of-file on communication channelCause: The connection between the Client and Server process was broken. It may also happen if the external agent extproc crashes for some reason.Action: There was a communication error that requires further investigation. First, check for …
ORA-03113: end-of-file on communication channel Read More »
