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 …
Aggregate functions in oracle 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 …
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 …
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 »
