Sql stands for Structured Query Language. is the language to communicate with the rdbms. plsql is the programming part of sql
Oracle sql and plsql are the languages which are widely used. They are easy to learn and apply. Here I would be listing out all the articles on Oracle sql and plsql
I am starting the basics so it is very helpful for the beginners to run sql and plsql here
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-00934 group function is not allowed here Read More »
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 …
As part of learning the Oracle SQL tutorial, Here is good detail on the Aggregate functions in oracle Aggregate functions in oracle/Group Functions Group Functions unlike single value functions operate on the set of rows and return one row per group. The set of rows may be a whole table or the table split into groups …
In this post we will discuss about PLSQL Constants in Oracle, How do you declare a constant variable in PL SQL, how to Declare a constant in Oracle stored procedure Oracle PLSQL Constant Oracle PLSQL constant is just like any other procedural language and Its value does not change during the execution of the program …
In this post we will learn about PLSQL language, What is PL/SQL, and Why Use PLSQL What is PL/SQL PL/SQL is Oracle’s proprietary extension to SQL that allows for procedural language capabilities It gives all the features of modern software engineering such as data encapsulation, exception handling, information hiding and object orientation It is also …
Here we will be discussing about Oracle PLSQL Block Structure and types, what is pl sql block in oracle, and what is pl sql block structure, how to write pl sql block what is pl sql block PL SQL is a block-structured language. Here we divided programs into logical blocks PLSQL Block Structure A plsql …
what is pl sql block : Structure & syntax Read More »
