siva123prasad

Cursors in pl sql

A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is referred to as the active set. You can name a cursor so that it could be referred to in aContinue reading “Cursors in pl sql”

Basics of Sql

Section 1. Querying data This section helps you learn how to query data from the SQL Server database. We will start with a simple query that allows you to retrieve data from a single table. SELECT– show you how to query data against a single table. Section 2. Sorting data ORDER BY– sort the resultContinue reading “Basics of Sql”

Importance Tools in Msbi technology

MSBI represents Microsoft Business Intelligence. This incredible suite is made out of instruments which helps in giving best answers for Business Intelligence and Data Mining Queries. This apparatus utilizes Visual studio alongside SQL server. It enable clients to access exact and modern data for better basic leadership in an association. It offers various devices forContinue reading “Importance Tools in Msbi technology”

concept of pl sql

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you greatContinue reading “concept of pl sql”

My First Blog Post

Be yourself; Everyone else is already taken. — Oscar Wilde. This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.

Introduce Yourself (Example Post)

This is an example post, originally published as part of Blogging University. Enroll in one of our ten programs, and start your blog right. You’re going to publish a post today. Don’t worry about how your blog looks. Don’t worry if you haven’t given it a name yet, or you’re feeling overwhelmed. Just click theContinue reading “Introduce Yourself (Example Post)”