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-00979: not a group by expression Read More »
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 »
In this post we will discuss about PLSQL Variables in Oracle, Types of Variable, how to Declare variable in Oracle procedure, how to Declare variable in Oracle stored procedure, Scope of plsql Variables Oracle PLSQL Variable Oracle PLSQL Variable are just like any other procedural language and it is used to store the result of
What is Oracle PLSQL Variable Read More »
dba_ind_columns : This is to used if login with user having DBA role all_ind_columns : This is to used if login with user having normal role user_ind_columns : This is to used if login with user having normal role How to check the index on the table in Oracle We can use the below query
How to check index on the table in Oracle Read More »
