plsql-tutorials.blogspot.com
PL/SQL Triggers - PL/SQL Tutorials
http://plsql-tutorials.blogspot.com/2006/10/plsql-triggers.html
PL/SQL Tutorials covers PL/SQL Introduction, PL/SQL Cursors, PL/SQL Triggers, PL/SQL Interview Questions. Wednesday, October 25, 2006. Is a block of code that is automatically executed in response to certain events. Triggers. Are executed implicitly whenever the triggering event happens. The triggering event is either a INSERT, DELETE, or UPDATE command. The timing can be either BEFORE or AFTER, INSTEAD OF trigger. Example of creating a trigger. Based on the following two tables:. We will create a trigger.
sql-tutorials.blogspot.com
SQL Joins - SQL Tutorials
http://sql-tutorials.blogspot.com/2006/10/sql-joins.html
Saturday, January 20, 2007. The simplest JOIN is a two-table SELECT. That has no WHERE. The number of rows in the result table is equal to the number of rows in the first source table multiplied by the number of rows in the second source table. Is a join with a join condition containing an equality operator. An equijoin combines rows that have equivalent values for the specified columns. Here is an example from the hr schema). It is without the WHERE. Select * from locations, departments;. If you have ma...
plsql-tutorials.blogspot.com
PL/SQL Introduction - PL/SQL Tutorials
http://plsql-tutorials.blogspot.com/2006/10/plsql-introduction.html
PL/SQL Tutorials covers PL/SQL Introduction, PL/SQL Cursors, PL/SQL Triggers, PL/SQL Interview Questions. Thursday, October 26, 2006. This tutorial covers PL/SQL. Cursors, procedures, functions and packages and much more in best of its form. You will love to read the content of this tutorial. It is an ever increasing tutorial. I will keep on adding more PL/SQL. Content from time to time. Below is the basic structure of the PL/SQL. Var1 := "Hello World";. Dbms output.put line(var1);. Hire date Date;.
sql-tutorials.blogspot.com
SQL Delete - SQL Tutorials
http://sql-tutorials.blogspot.com/2006/10/sql-delete.html
Friday, January 19, 2007. How to delete all records from a table? Delete from dept;. How to delete specific records from a table? Delete from emp where empno=20;. How to delete duplicate records from the table? Suppose we have a table t1(id integer, name varchar(10). Select * from t1;. Where id not in ( select min(id). Group by name ). BOTH THE BELOW EXAMPLES OF UPDATE AND DELETE USE CORRELATED SUBQUERIES:. Sal = (SELECT MAX(sal). E1deptno = e2.deptno);. Deptno = e.deptno);. Posted by sachin : 12:36 AM.
plsql-tutorials.blogspot.com
PL/SQL Sitemap - PL/SQL Tutorials
http://plsql-tutorials.blogspot.com/2007/03/plsql-sitemap.html
PL/SQL Tutorials covers PL/SQL Introduction, PL/SQL Cursors, PL/SQL Triggers, PL/SQL Interview Questions. Monday, January 09, 2006. 4 PL/SQL Interview Questions. Posted by sachin @ 12:08 AM. PL SQL Tutorials Home. Http:/ sql-tutorial.blogspot.com/. PL/SQL, Oracle Tutorials:. Http:/ plsqll.googlepages.com/.
plsql-tutorials.blogspot.com
PL/SQL Resources - PL/SQL Tutorials
http://plsql-tutorials.blogspot.com/2007/02/plsql-resources.html
PL/SQL Tutorials covers PL/SQL Introduction, PL/SQL Cursors, PL/SQL Triggers, PL/SQL Interview Questions. Tuesday, September 19, 2006. Http:/ www.sqlzoo.net. Http:/ www.w3schools.com. Http:/ asktom.oracle.com. Http:/ metalink.oracle.com/. Http:/ www.ioug.org/. Pl SQL Tutorials Blog. Posted by sachin @ 11:48 PM. PL SQL Tutorials Home. Http:/ sql-tutorial.blogspot.com/. PL/SQL, Oracle Tutorials:. Http:/ plsqll.googlepages.com/.
plsql-tutorials.blogspot.com
PL/SQL Interview Questions - PL/SQL Tutorials
http://plsql-tutorials.blogspot.com/2006/10/plsql-interview-questions.html
PL/SQL Tutorials covers PL/SQL Introduction, PL/SQL Cursors, PL/SQL Triggers, PL/SQL Interview Questions. Wednesday, October 25, 2006. SQl PL/SQL Question 1. How to display row number with records? Select rownum, ename from emp;. SQl PL/SQL Question 2. How to view version information in Oracle? Select banner from v$version;. SQl PL/SQL Question 3. How to find the second highest salary in emp table? Select min(sal) from emp a. Select count(*) from emp b where a.sal b.sal) ;. SQl PL/SQL Question 4. SELECT ...
plsql-tutorials.blogspot.com
PL/SQL Cursors - PL/SQL Tutorials
http://plsql-tutorials.blogspot.com/2006/10/plsql-cursors.html
PL/SQL Tutorials covers PL/SQL Introduction, PL/SQL Cursors, PL/SQL Triggers, PL/SQL Interview Questions. Wednesday, October 25, 2006. Are automatically created and used by Oracle every time you issue a select statement in PL/SQL. If you use an Implicit cursors. Oracle will perform the open, fetches, and close for you automatically. Implicit cursors. Are used in statements that return only one row. If the SQL. Statement returns more than one row, an error will occur. In the following PL/SQL. Block Once y...
sql-tutorials.blogspot.com
SQL Views - SQL Tutorials
http://sql-tutorials.blogspot.com/2006/10/sql-views.html
Thursday, January 18, 2007. A view is a specific representation of data from one or more tables. The tables referred in the views are known as Base tables. Creating a view. Does not take any storage space as only the query is stored in the data dictionary and the actual data is not stored anywhere. The maximum number of columns that an be defined in a view. Are 1000 as in tables. The reasons for using views in applications can be many like;. Renaming the table columns. Statement to create a view:. And re...
SOCIAL ENGAGEMENT