|
|
|
|
|
|
|
Creating a View in PL/SQL InPLSQL |
| With a view you can build a select statement and then everytime you call the view it runs without you needing to build the SQL statement again. So if I created this View:... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:5129 |
|
|
| |
|
Creating a Sequence in PL/SQL InPLSQL |
| sequence specifies a unique value. This one will give us the number 1 the first time we use it. Then it will give us 2 then 3 etc.. if for some reason the order gets messed up it will skip 20 numbers then give us the next number in the sequence.... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:6630 |
|
|
| |
|
Selecting the Next available Sequence number in PL/SQL InPLSQL |
| The Dual table is a special table that exists in oracle, it keeps track of sequence information for you. You can query it to return the next number in your sequence like this:... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:3560 |
|
|
| |
|
Creating a Synonym in PL/SQL InPLSQL |
| There are many uses for Synonymns, this is but one small example of using the Synonym Client to refer to the Customer Table... read more
|
| Author: mobeenamjad |
Reviews:1 |
Date:12th Jun, 2007 |
Rating: |
Accessed:3952 |
|
|
| |
|
Deleting Constraints with a Table in PL/SQL InPLSQL |
| Deleting Constraints with a Table in PL/SQL... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:2575 |
|
|
| |
|
Determining if a Operation Worked in PL/SQL InPLSQL |
| You can use the %NOTFOUND parameter to determine if the update was sucessful, and then insert if the update did not work... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:1721 |
|
|
| |
|
A Simple Loop in PL/SQL InPLSQL |
| A Simple Loop in PL/SQL... read more
|
| Author: mobeenamjad |
Reviews:1 |
Date:12th Jun, 2007 |
Rating: |
Accessed:3010 |
|
|
| |
|
Creating a Cursor in PL/SQL InPLSQL |
| Creating a Cursor in PL/SQL... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:2595 |
|
|
| |
|
Loading Data from a Cusor in PL/SQL InPLSQL |
| This creates a cusor and then keeps looping until it has reached the end of the data using %NOTFOUND.... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:1835 |
|
|
| |
|
Creating a Trigger in PL/SQL InPLSQL |
| This trigger will be added to the Customer table and will stop you from entering people whos name has the word SMITH in it.... read more
|
| Author: mobeenamjad |
Reviews:0 |
Date:12th Jun, 2007 |
Rating:No Rating |
Accessed:3520 |
|
|
| |
|
|
|
|
