Skip to main content

SQL Varrays

Example 01:

DECLARE 

CURSOR NAME_CUR IS
SELECT LAST_NAME FROM STUDENT WHERE ROWNUM<=10;

TYPE LASTNAME_TYPE IS VARRAY(10) OF STUDENT.LAST_NAME % TYPE;
LAST_NAME_VARRAY LAST_NAME=LASTNAME_TYPE();

V_COUNT INTEGER=0;

BEGIN
FOR NAME_REC IN  NAME_CUR LOOP
 V_COUNT=V_COUNT+1;
 LAST_NAME_VARRAY(V_COUNT)=NAME_REC.LAST_NAME;
 DBMS_OUTPUT.PUT_LINE('LAST NAME('||V_COUNT||'):'||LAST_NAME_VARRAY(V_COUNT));
END LOOP;
END;

Example 02:

DECLARE

TYPE MY_VARRAY_TYPE IS VARRAY(10) OF NUMBER;
VARRAY MY_VARRAY_TYPE=MY_VARRAY_TYPE(1,2,3,4);

BEGIN
DBMS_OUTPUT.PUT_LINE('MY VARRAY COUNT='||VARRAY.COUNT);
DBMS_OUTPUT.PUT_LINE('MY VARRAY LIMIT='||VARRAY.LIMIT);
DBMS_OUTPUT.PUT_LINE('MY VARRAY FIRST='||VARRAY.FIRST);
DBMS_OUTPUT.PUT_LINE('MY VARRAY LAST='||VARRAY.LAST);
VARRAY.EXTEND(2,4)
DBMS_OUTPUT.PUT_LINE('MY VARRAY LAST='||VARRAY.LAST);
DBMS_OUTPUT.PUT_LINE('MY VARRAY('||VARRAY.LAST||')='||VARRAY(VARRAY.LAST));
VARRAY.TRIM(2);
DBMS_OUTPUT.PUT_LINE('MY VARRAY LAST='||VARRAY.LAST);
END;

MY_VARRAY.COUNT=6
MY_VARRAY.LIMIT=10
MY_VARRAY.FIRST=1
MY_VARRAY.LAST=8
MY_VARRAY(8)=4
MY_VARRAY.LAST=6

Comments

Popular posts from this blog

Behavior Driven Development

Behavior Driven Development (BDD) is a development process that originally associated with Test-Driven Development (TDD).  BDD is written in a readable format in an understandable language for anyone involved in software development.  BDD Features Providing better readability and visibility.  Verifying the software against customer requirements.  Assure the implementation of the system is correct. Derives examples of different expected behaviors of the system. Uses examples as acceptance tests. Focus on customer requirements throughout the development. BDD Practice There are two practices in BDD:-  Specification by Example (SbE). Test-Driven Development (TDD). Specification by example (SbE) uses examples in conversation to illustrate the business rules and the behavior of the software.  This uses to have a better understanding for Business Analyst, Product Owners, Testers and the Developers to reduce the misunderstanding abou...

Scraping HTML Content using Python

To Scrape Data using python we are using BeautifulSoup python Package !pip install beautifulsoup4 As a first step we have to import the packages and html page that we need to scrape. In here I have used some static HTML content which was customized to scrape the data. #imports import requests from bs4 import BeautifulSoup #html HTML Sample Doing Data Science with Python Doing Data Science with Python Author: Eranda Kodagoda This will help to perform various data science activitied using python Modules Title Duration in minutes Getting Started 20 Setting Up Environment 40 Extracting Data 30 Exploring and Processing Data 45 Building Productive Model 45 To View the HTML using beautifulsoup we can use below code-lines and execute on python executor from IPython.core.display import display, HTML display(HTML(html_string)) To Print the HTML using beautifulsoup we can use below code-lines and execute on python executor ps=Be...

Basics of Data Science with Python

About Data Science with Python From this module I will post some interesting posts about Data science and how to gather information and process them using Python and for that I will be using below softwares  Python 3.6 Anaconda Jupyter Notebook PyCharm by JetBrains In the posts I will include fundamentals of Python  programming techniques such as lambdas, reading and manipulating csv files, and the numpy library. And In the posts I will be doing a simple Data Challange which is available on Kaggle and I will provide the URL's to the github repo which I will be posting the whole module once it finished. In Future I will be post some articles related to Applied Data Science with Python: Applied Plotting, Charting & Data Representation in Python, Applied Machine Learning in Python, Applied Text Mining in Python, Applied Social Network Analysis in Python