PL-SQL-Strings- Learn how to declare string variables and initialization of values into them. PL-SQL-Strings A string is a collection of characters with in a single
Use of volatile keyword in Java – The volatile keyword is used to declare a variable volatile, so, the variable can be accessed directly from
Q) Which keyword is used to declare an interface in java? class interface implements abstract Answer: 2Interface keyword is used to create an interface in
Learn loose coupling in java with simple COMPARISON code EXAMPLE with tight coupling. First tightly coupled code then the loosely coupled code. Advantage and disadvantage of it.
ORACLE Rank and Dense_rank functions – Learn how to calculate nth maximum and minimum value in the result set based on the ranking mechanism either
ORACLE-VIEWS-Learn about features of oracle views ,how to create view, and how to perform insert,update,delete operations on views with super simple explanation with examples. ORACLE-VIEWS
ORACLE-INDEX- Learn about different types of index available in oracle and how to create index ,rename index and drop index. ORACLE-INDEX Index sorts the data
Learn PL/SQL functions with simple explanation with examples. PL-SQL-Functions A FUNCTION is a named PL-SQL block that may or may not take a values as
PL-SQL-Procedures Learn procedures in PL-Sql with simple explanation with examples. PLSQL PROCEDURES Procedure is a PL/SQL block/group of statements that can be called by name.
PL/SQL Case Statement -Learn use of case statements in pl-sql programming with simple explanation and example. PL/SQL Case Statement CASE Statement similar to SWITCH statement