Tecmints

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           ...

Introduction to SEO (Search Engine Optimization) Search Engine Optimization is a full form of SEO. SEO is the process of increasing the online ranking visibility of the website in a web search engine’s unpaid results also called as natural or organic results. Search engine optimization is the process of optimizing online content or web-page content that a search engine likes to show as a top result for searches of a relevant keyword. SEO is a collection of tools and practices that are help website rank higher in search results. Users trust search engines and achieving a highest in search engine ranking signals to searchers that your site is a reliable source. SEO is following the Google way to determine that which sites deserve to rank high for every query entered into its search engine. The websites high rank in result pages, it means more click and traffic will generate on your website. Search Engine Optimization improves user experience and making it mo...