Skip to main content

Featured post

5 Super SEO Blogger Tools

In this post, I have explained top blogging tools that need to be considered by every blogger. These tools help you write better SEO friendly blog posts.



1). Headline Analyzer The best tool is the EMV Headline Analyzer. When you enter the headline it analyzes it and gives you EMV ranking. When you get '50' and above it performs better SEO.

2). Headline Length Checker The usual headline length is 50 to 60 characters. Beyond that, the headline will get truncated and looks ugly for search engine users. The tool SERP Snippet Optimization Tool useful to know how it appears in the search results.

3). Free Submission to Search Engines The tool Ping-O-Matic is a nice free submission tool. After your blog post, you can submit your feed to Ping-O-Matic. It submits to search engines freely.

4). Spell and Grammar Check Another free tool is Grammarly, this tool checks your spelling and grammar mistakes. So that you can avoid small mistakes.

5). Keyword AnalyzerWordstream Keyword analyzer i…

PL/SQL: Popular Reserved Words

To become perfect in PL/SQL is an art. Knowing of top reserved words helps you to be a master in SQL.

pl sql reserved words

Top List of PL/SQL Reserved Words..

Before you start knowing reserved words, wait one moment. The reserved words all are similar to words that you use in normal SQL.
  • ALL*
  • DESC*
  • ISOLATION
  • OUT
  • SQLERRM
  • ALTER*
  • DISTINCT*
  • JAVA
  • PACKAGE
  • START*
  • AND*
  • DO
  • LEVEL*
  • PARTITION
  • STDDEV
  • ANY*
  • DROP*
  • LIKE*
  • PCTFREE*
  • SUBTYPE
  • ARRAY
  • ELSE*
  • LIMITED
  • PLS_INTEGER
  • SUCCESSFUL*
  • AS*
  • ELSIF
  • LOCK*
  • POSITIVE
  • SUM
  • ASC*
  • END
  • LONG*
  • POSITIVEN
  • SYNONYM*
  • AUTHID
  • EXCEPTION
  • LOOP
  • PRAGMA
  • SYSDATE*
  • AVG
  • EXCLUSIVE*
  • MAX
  • PRIOR*
  • TABLE*
  • BEGIN
  • EXECUTE
  • MIN
  • PRIVATE
  • THEN*
  • BETWEEN*
  • EXISTS*
  • MINUS*
  • PROCEDURE
  • TIME
  •  BINARY_INTEGER
  • EXIT
  • MINUTE
  • PUBLIC*
  • TIMESTAMP
  • INTEGER
  • EXTENDS
  • MLSLABEL*
  • RAISE
  • TO*
  • BODY
  • FALSE
  • MOD
  • RANGE
  • TRIGGER*
  • BOOLEAN
  • FETCH
  • MODE*
  • RAW*
  • TRUE
  • BULK
  • FLOAT*
  • MONTH
  • REAL
  • TYPE
  • BY*
  • FOR*
  • NATURAL
  • RECORD
  • UID*
  • CHAR*
  • FORALL
  • NATURALN
  • REF
  • UNION*
  • CHAR_BASE
  • FROM*
  • NEW
  • RELEASE
  • UNIQUE*
  • FUNCTION
  • NEXTVAL
  • RETURN
  • UPDATE*
  • CHECK*
  • GOTO
  • NOCOPY
  • REVERSE
  • USE
  • CLOSE
  • GROUP*
  • NOT*
  • ROLLBACK
  • USER*
  • CLUSTER*
  • HAVING*
  • NOWATT*
  • ROW*
  • VALIDATE*
  • COLLECT
  • HEAP
  • NULL*
  • ROWID*
  • VALUES*
  • COMMENT*
  • HOUR
  • NUMBER*
  • ROWLEBEL
  • VARCHAR*
  •  COMMIT
  • IF
  • NUMBER_BASE
  • ROWNUM*
  • VARCHAR2*
  • COMPRESS*
  • IMMEDIATE*
  • OCIROWID
  • ROWTYPE
  • VARIANCE
  • CONNECT*
  • IN*
  • OF*
  • SAVEPOINT
  • VIEW*
  • CONSTANT
  • INDEX*
  • ON*
  • SECOND
  • WHEN
  • CREATE*
  • INDICATOR
  • OPAQUE
  • SELECT*
  • WHENEVER*
  • CURRENT*
  • INSERT*
  • OPEN
  • SEPARATE
  • WHERE*
  • CURRVAL
  • INTEGER*
  • OPERATOR
  • SET*
  • WHILE
  • CURSOR
  • INTERFACE
  • OPTION*
  • SHARE*
  • WITH*
  • DATE*
  • INTERSECT*
  • OR*
  • SMALLINT*
  • WORK
  • DAY
  • INTERVAL
  • ORDER*
  • SPACE
  • WRITE
  • DECLARE
  • INTO*
  • ORGANIZATION
  • SQL
  • YEAR
  • DECIMAL*
  • IS*
  • OTHERS
  • SQLCODE
  • ZONE
  • DEFAULT*
  • DELETE* 

A Video on Basic PL/SQL..

Related Posts





  • 32 Complex SQL Queries popular e book
  • Introduction to SQL and PLSQL by Ruchin Jain

    Comments

    Most Viewed

    Tokenization story you need Vault based Vs Vault-less

    The term tokenization refers to create a numeric or alphanumeric number in place of the original card number. It is difficult for hackers to get original card numbers.

    Vault-Tokenization is a concept a Vault server create a new Token for each transaction when Customer uses Credit or Debit Card at Merchant outlets 
    Let us see an example,  data analysis. Here, card numbers masked with other junk characters for security purpose.

    Popular Tokenization ServersThere are two kinds of servers currently popular for implementing tokenization.
    Vault-based Vault-less Video Presentation on Tokenization
    Vault-based server The term vault based means both card number and token will be stored in a Table usually Teradata tables. During increasing volume of transactions, the handling of Table is a big challenge.
    Every time during tokenization it stores a record for each card and its token. When you used a card multiple times, each time it generates multiple tokens. It is a fundamental concept.
    So the challe…