2012-10-15 20:18
Environment: Oracle 10gR2Summary of the testing steps1. First, configure RMAN to perform a control file autobackup:2. Next, perform a backup with the control file autobackup enabled:3. Next… Read More
Blog Directory > Software Blogs > Programming Blogs > Programming Is Fun programming Blog >
Programming Is Fun Blog
programmingversatality.blogspot.com
Tags:
cursor
plsql cursors
loop statement
yqgcbaddress dccechildaddress
backup
stored procedure
explicit cursors
column
spexecutesql
implicit cursor
This blog consists of resources which are related closely to programming. books and concepts are available for SQL, PL SQL,UNIX and Linux for free...
2012-10-14 19:29
If I have a relatively big table and I want to modify a column from one type to another, i.e. number to varchar2(50), I may experience very long time. Note if I just change, for example, fro… Read More
2012-10-08 21:28
We can manipulate the information within a SQL statement by means of assigning a name to a "select statement", this concept is known a cursor. A cursor is used for processing individual rows… Read More
2012-10-08 20:29
The cursor FOR LOOP statement implicitly declares its loop index as a record variable of the row type that a specified cursor returns and opens a cursor. With each iteration the cursor FOR L… Read More
2012-10-01 09:28
Implicit cursors. Explicit cursors. PL SQL cursors.A REF CURSOR or cursor variable is just a reference or a handle to a static cursor. It allows a user to pass this "reference to… Read More
2012-10-01 09:09
PL SQL ref cursors. PL SQL cursors. Explicit Cursors Programmers create explicit cursors, and with these you can do operations on a set of rows, which can be processed… Read More
2012-10-01 09:00
Explicit cursors PL SQL cursors.Implicit cursors are automatically created and used by Oracle every time you issue a Select statement in PL/SQL. If you use an implicit cursor, Or… Read More
2012-09-30 06:50
[sp_executesql in comparison to Execute] If you want to have the flexibility of dynamic SQL, but the persistence of a stored query plan, consider using sp_executesql in your stored proc… Read More
2012-09-30 06:48
EXECUTE The EXECUTE, or EXEC statement executes a stored procedure by following the command with the name of the stored procedure and any proper parameter arguments: EXEC sp_Empfin… Read More
2012-09-29 19:27
In a pre-production test, I find out that application did not use bind variables and there was no time to change code before the production rollout. So we suggested changing CURSOR_SHARING p… Read More
2012-09-12 21:12
SQL Group By Examples of SQL Group By and SQL Having Null in SQL Group By The SQL HAVING clause… Read More
2012-09-12 07:42
SQL is a tool for organizing managing and retrieving data stored by a computer database. The acronym SQL is an abbreviation for structured Query Language for historical reasons SQL is usual… Read More
2012-09-12 07:41
ASP.NET 2.0 Unleashed by Stephen WaltherProfessional ASP.NET 2.0 Special Edition (Wrox Professional Guides) by Bill evjen Scott Hansleman Farhan Muhammad Srinivasa SivakumarProfessional ASP… Read More
2012-09-12 07:40
On this page, you will find SQL syntax for some of the most important SQL commands. These below SQL Syntaxes will be suitable for quick reference.SELECT [hint][DISTINCT] select_listFROM tabl… Read More
2012-09-12 07:40
SQL is a simple, yet powerful, language used to create, access, and manipulate data and structure in the database.SQL Statements categories: DDL - Data Definition Language.DDL is used… Read More
2012-09-12 07:39
SQL Cookbook (Cookbooks (O'Reilly)) by Anthony MolinaroSams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben FortaLearning SQL by Alan BeaulieuSQL For Dummies by Allen G TaylorSQL Queri… Read More
2012-09-12 07:38
Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) by Steven Feuerstein and Bill PribylOracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 by… Read More
2012-09-08 11:42
The SELECT statement retrieves data from a database and returns it you in the form of query results. For simple queries, the English language request and the SQL SELECT statement are very si… Read More
2012-09-08 11:11
The explicit join is easier to read and the implicit syntax is difficult to understand and more prone to errors. Moreover implicit syntax is now a day’s outdated. SQL specifies tw… Read More
2012-09-08 11:10
SQL Having SQL Group By Null in SQL Group BySome of the examples found on the Internet:Find the average sales price for each bee… Read More
2012-09-08 11:10
Examples of Inner Join, Left Outer Join, Right Outer Join & Full JoinAn Example of INNER JOIN The "Persons" table:P_Id LastName FirstName Address City 1 Hansen Ola Timo… Read More
2012-09-08 11:10
SQL Having SQL Group By Examples of SQL Group By and SQL HavingIt is known that Null Null. When two different NULL values… Read More
2012-09-08 11:10
Inserting a new row into the dept tableInsert into dept (deptno, dname, loc)values (10,'Apple','Boston')You can omit the column list in the insert statement but then you have to enter those… Read More
2012-09-08 11:10
PurposeThis tutorial shows you how to use the SQL Tuning Advisor feature in Oracle SQL Developer 3.0.Complete timeApproximately 20 minutes.OverviewThe SQL Tuning Advisor analyzes high-volume… Read More
2012-09-08 11:10
SQL Having Examples of SQL Group By and SQL Having Null in SQL Grou… Read More
2012-09-03 09:34
Tables
are PL/SQL constructs. PL/SQL is a linguistic extension of the Oracle SQL
language, but it is distinct from SQL. When PL/SQL executes a SQL DML statement
(SELECT, INSERT, UPDATE… Read More
2012-09-03 09:22
Contents:
Characteristics
of PL/SQL TablesPL/SQL
Tables and DML Statements
PL/SQL
Tables and Other Collections Declaring
a PL/SQL Table
Referencing
and Modifying PL/SQL Table Rows Filli… Read More
2012-09-02 21:14
PL/SQL stands for
Procedural Language/SQL. PL/SQL is Oracle's Procedural Language extension to
SQL. PL/SQL expands SQL by adding constructs found in procedural languages,
resulting in a st… Read More
2012-09-02 21:11
Contents:
Table-Based Records Cursor-Based Records Programmer-Defined Records Assigning Values to and from Records Record Types and Record Compatibility
Nested Records
Records
in P… Read More
2012-09-02 20:07
Record
Types and Record Compatibility
As
we have discussed, PL/SQL supports three types of records: table-based,
cursor-based, and programmer-defined. A record is defined by its name… Read More
2012-09-02 20:00
You
can modify the values in a record in the following ways:
·
Direct
field assignment with the… Read More
2012-09-02 19:48
Now
you know how to create a record with the same structure as a table or a cursor.
These are certainly very useful constructs in a programming language designed
to interface with the Or… Read More
2012-09-02 19:39
A
cursor-based record, or cursor record, is a record whose structure is drawn
from the SELECT list of a cursor. Each field in the record corresponds to and
has the same name as the col… Read More
2012-09-02 19:29
A
table-based record, or table record, is a record whose structure (set of
columns) is drawn from the structure (list of columns) of a table. Each field
in the record corresponds to an… Read More
2012-08-29 11:09
Control statements are the most important PL/SQL extension to SQL.
PL/SQL has three categories of control statements:
■ Conditional selection statements: this let you r… Read More
2012-08-29 11:03
Data Abstraction
Data abstraction lets you work with the essential properties of
data without being too involved with details. You can design a data structure
first, and then design… Read More
2012-08-29 10:42
Subprograms
A PL/SQL subprogram is a named PL/SQL block that can be invoked
repeatedly. If the subprogram has parameters, their values can differ for each
invocation. PL/SQL has two typ… Read More
2012-08-29 06:31
SQL stands for Structured Query
Language. and it is
generally referred to as SEQUEL. SQL is simple language to learn. SQL is
a Non-procedural language, as compared to the procedural or th… Read More
2012-08-29 06:26
PL/SQL
combines the data-manipulating power of SQL with the processing power
of procedural languages. When you can solve a problem with SQL, you can
issue SQL statements from your PL/SQL… Read More
Subscribe to Programming Is Fun
Get updates delivered right to your inbox!