Tecmints

Collection Types in PL/SQL Types : Type is nothing but user_defined datatype. In oracle we can create our own datatype. We can create user_defined datatype by using type keyword.There are various types of collection in Pl/SQL following lines. 1)PL/SQL record 2) index by table (or) pl/sql table (or) associative array 3) nested table 4) Varray 5)ref cursor* (will be in next) Note: where index by table ,nested table and Varray are also known as collections. Index by table: It is a type. Which stores number of values into a single unit. It improves application performance because it stored in RAM MEMORY AREA.Index by table has key-value pair. Where key behaves like a primary key. which stores index. Key doesn't have any duplicate value in it. Where value is actual data. To improve performance of the index by table oracle provided binary_integer datatype for key field. Index by table,nested table, Varray are also called as collections. Oracle provided predefi...

What is trigger? TRIGGER : -->  SQL Trigger is an event-driven action or database callback function which is invoked automatically when an INSERT, UPDATE, and DELETE statement is performed on a specified table. The main tasks of triggers are like enforcing business rules, validating input data, and keeping an audit trail. Usage of Triggers: 1. Triggers are used for enforcing business rules. 2. Validating input data. 3.Generating a unique value for a newly-inserted row in a different file. 4.Write to other files for audit trail purposes. 5. Query from other files for cross-referencing purposes. 6. Used to access system functions. 7. Replicate data to different files to achieve data consistency. Advantages of using triggers Triggers make the application development faster. Because the database stores triggers, you do not have to code the trigger actions into each database application. Define a trigger once and you can reuse it for many applications that use...

What is a Function in Oracle PL/SQL Function : The PL/SQL Function is very identical to PL/SQL Procedure.The big dissension between procedure and a function, a function essential always return a value, but procedure may or may not return a value.     Functions is also used to solve a particular task like procedure. Function always returns a value.Oracle provided us a facility to create our own functions to solve any task.   How To Create a function    Syntax: Create or replace function p1 (formal parameters) return datatype is variable,cursor, user_defined exception  begin ...... return expression; // Do not use dbms_output.put_line() exception ....... end; _________________________________________________________________________________ Execution: Method 1:   Select function_name from dual; Method 2: By anonymous block           Syntex:           declare ...

   Different Types of SEO There are three main types of SEO (Search Engine Optimization), these are helped you to increase your rankings and advantage and disadvantage  but there are differences in them that is discussing later. Here discuss types of SEO that's are given below: * White Hat SEO * Black Hat  SEO * Grey Hat  SEO White Hat SEO The White hat SEO is considered to all Google’s algorithms and does not aim at harness crack in the same. The White hat SEO refers to the most legalized.  It’s using different techniques which ensure site performance well in the SERPs without recline to what essentially many people now refer to as cheating. White hat SEO uses organic techniques and demands quality in a site in order to confirm it performs well for search. it means severals reason have to taken into reflection and optimized like as: It mainly focuses on search engine’s and on the human audience opposed, p...

What is Procedure in Oracle/PL/SQL? Procedure:  Procedure is named PL/SQL block. Which is used to solve particular task. It is stored into database that's why it is also called as stored procedure. Stored procedure:  When we are using create or replace in front of procedure then it is saved into database.So it is called stored procedure. Procedure is used to improve performance of our application because it has one time compilation process. Procedure has two parts. a)Procedure Specification:  In this section we create procedure name. b)Procedure Body:  In this section we specify actual task.       Create or replace Procedure Procedure_Name(Parameter_Name  [Mode] datatype)    // Procedure specification        is/as           variable,cursor,exception declaration .                         // Procedure Body...

What is SQL? SQL stands for “Structured Query language” .   It’s a standard language for accessing and manipulating Databases. American National Standard Institute standardized SQL in 1986 and standardized in1987 by International Organization of Standardization. Through SQL you can Execute queries v/s Database. With the help of SQL you can insert data into the database table, or if you want to drop or delete any record from your table then you can perform these tasks easily with the help of simple Queries of   SQL. Some important commands of Structured Query language: and these are as follows. DDL :   extends for Data Definition Language. DDL Can’t be rollback. The commands are – 1        Create :   this command is used to create the New table. The syntax is as follows. Syntax :                 Create table table_name           ...