Plsqltutorials - plsqltutorials.com - SQL and PLSQL Tutorials
General Information:
Latest News:
SQL Literal example 23 Aug 2012 | 03:39 am
Literal Character Strings in a SELECT statement A literal is any number, character or a date included in the SELECT statement Character and Date literals, if specified, must be enclosed within singl...
SQL SELECT statement 19 Aug 2012 | 06:36 pm
SQL SELECT statement capabilities / Examples The following can be done with the SELECT statement: Projection: The Projection capability in SQL is used to choose the columns in a table that you want yo...
SQL operators used along with Where condition in SQL 15 Aug 2012 | 09:27 am
SQL operators between, in, like isNull etc.. Above operators can be used along with where condition in SQL commands. Description: BETWEEN …AND… –Used to search between two values (inclusive) IN ...
Expressions in SQL 24 Jul 2012 | 07:18 am
Using Expressions in a SELECT statement example Expressions consists of many combinations of arithmetic operators that can be used in the SELECT, WHERE and ORDER BY clauses of a SQL SELECT statement....
Concatenation in SQL 23 Jul 2012 | 06:46 am
Using the Concatenation Operator To display the full name of the employees in the COMPANY_EMPLOYEES table in one column, we can use the || (concatenation) operator.( The | symbol can usually be fo...
Business Analyst and SQL knowledge 7 Jul 2012 | 06:41 pm
Some Myths / Questions about Business Analyst and SQL: Is it a must for a Business Analyst to learn SQL to get and sustain in a job? A Business Analyst must be expert in SQL as well. Can I become ...
SQL Where clause 28 Jun 2012 | 07:05 pm
The WHERE Clause examples The WHERE clause can be used to restrict the rows that are returned by a query. The rows are resstricted based on a condition in the WHERE clause. The syntax of a WHERE clau...
SQL Distinct Example 11 Jun 2012 | 06:45 am
Using the DISTINCT Keyword The DISTINCT keyword can be used to eliminate the duplicate rows by including it immediately after the SELECT keyword in the SELECT statement. For example in the COM...
What is SQL definition 29 May 2012 | 10:41 pm
SQL Definition and Introduction SQL stands for Structured Query Language. Some times it is also referred as “SeQuel”. The common definition of SQL is “It is a Database Programming Language which is ...
PL SQL Cursor 13 Mar 2012 | 11:00 pm
PL SQL Cursor example: Well, this is really an interesting topic and many people still scared of the word ‘cursor’ thinking it might be something very complex. The answer is Yes & No. Once you unders...
