Brief about Company

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Practice report

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Abstract

 

This report investigates the current industrial environment and tools used in it. This programming environment or platform is based on Oracle DBMS. And one of the programming tools is PL/SQL and JAVA, which is used to manipulate with objects in this environment.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Table of contents

 

1. Introduction……………………………………………………………… 4
1. Brief about Company………………………………………………4
2. Type of tasks and the main aims…………………………….……..4
2. Body………………………………………………………………………5-16
1. Theory…………………………………………………………….. 5
2. Practice…………………………………………………………….6

2.2.0  Installation and Settings……………………………………. 6-15

2.2.1   PL/SQL……………………………………………………. 15-16

3. Conclusion …………………………………………………………… …17
4. Future developments……………………………………………………..18

5.0   Reference list……………………………………………………………..19

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Introduction

 

Brief about Company

 

This report contains the main aspects about industrial practice as a job experience in software company “Vega Partners ”, which works in the field of automation of the banking. 

 

 

 

Type of tasks and the main aims

 

The main aim is to investigate industrial environment and learn their tools such as PL/SQL and Oracle.

The position of interne is PL/SQL programmer.

The types of tasks are: Installation and Setting  and Programming in PL/SQL.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

BODY

 

    Theory

 

About  Oracle and PL/SQL

 

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.

Larry Ellison and his friends, former co-workers Bob Miner and Ed Oates, started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.¹

 

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database. PL/SQL's general syntax resembles that of Ada or Pascal.

PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java.

PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Practice

Installation and Settings

 

First step: Installing Oracle Database 10g

 

 

 

Basic installation

Password: qwe123

 

 

Wating…

 

 

Exit

 

 

After creating the database, check the connection by using pl / sql developer-the, password qwe123:

 

Then act on the file readme.txt (this guide to deploy the database) 
Instructions to deploy database 
 
In regional settings decimal separator must be the DOT.

(Control Panel\Regional and Language Options\Вкладка REGIONAL OPTIONS\Кнопка CUSTOMIZE\Поле Decimal Symbol)

 

In reestr hkey_local_machine\software\oracle\ the value of NLS_LANG must be AMERICAN_AMERICA.CL8MSWIN1251

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraDb10g_home1

 

*all scripts must be executed by user SYS as SYSDBA

 

0_TblSpace.pdc - script to create tablespaces 
1_Users.pdc - Script to create users 
Grants_432.pdc - Script for distribution rights to users 
 
The sequence of actions: 
 
1) Check the script 0_TblSpace for placing database files on the server.

 

2) Run the script 0_TblSpace 
3) Depending on what a dump pump up, drops of corresponding user if it exists (ARTDBA, ARTSYS, ARTADMIN). 
4) Run the script 1_Users.pdc (creating those whom dropped above). 
5) Upload files DUMP'ov as user SYSTEM (as NORMAL) as follows: 
Two. ARTADMIN 
Three. ARTSYS 
4. ARTDBA 
   
   How to download: 
   
   A. PLSQL Developer: 
   - Log in under the SYSTEM or ARTDBA 
   - Menu Tools / Import Tables, Tab 'Oracle Import' 
   - In the 'To User' must be specified acc. DUMPu user in the 'From User' is the same 
- In the 'Import file' specifies the file resp. user 
- Tick 'Analyze' should be removed

 

  

 

 

 

2. with the utility IMP.EXE: 
imp system / password @ service file = C: \ artadmin.dmp fromuser = artadmin touser = artadmin commit = Y grants = N rows = Y log = imp.log 
 
6) Run the script as user SYS

 

Grants_432.pd

 

c

 

 

7) Start the Art Bank: 
Version is in the directory VER. 
In the list the name of the file base_param.ini established base ServerName (now there is base432)

 

 

 

execute the file art-bank.exe to learn Information system…

Now you are able to code on PL/SQL…

 

 

PL/SQL

 

Before writing any SQL scripts login as

Artdba with password toren.

Initial tasks are devoted to SQL standart language.

 

SELECT p.lastname ||' ' || p.firstname|| ' ' || p.patronymic as LastName_FirstName_MiddleName, p.sex, p.birthdate,

   decode(p.deathdate, null, 'Alive', 'Died'|| p.deathdate)as LifeStatus,

   c.card as CardNumber,

   CASE

     WHEN (c.expdate - c.startdate > 100) THEN  'more than 100 days'

     WHEN (c.expdate - c.startdate = 100) THEN  '100 days'

     ELSE 'Less than 100 days'

   END as CardTimePeriod

   FROM person p, card c

   WHERE c.idperson = p.idperson AND c.startdate > to_date('01012000','mmddyyyy')

 

But at the end of the tasks were huge and more difficult.

We learned how to write procedures, functions, triggers and packages. But for me the new one was the package. For example, this is solution of task number 7 - writing a package:

Package contains two tabs: first one for declarations and second one for body definition.

This if a first tab…

This is a second tab…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Conclusion

 

In conclusion, there were many things that we experienced and learned. The whole training period was very interesting, instructive and challenging. Through the training we were able to gain insights and more comprehensive understanding about real industry. The practice gave me opportunity to develop and improve my soft and functional skills.

In conclusion, we investigated industrial environment especially programming sphere and learned PL/SQL. Moreover we approximately know entire infrastructure of this company.

As a result of the training we are more confident now to enter the employment world and build future careeer.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Future developments

 

Two weeks practice is not the end at all, but initial education and practice in that company. That is why our future development and the task will be investigating Banking system as one of the improved and huge Information system. My colleges and me are going study bank terminology, because it will be very useful to understand during implementation.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Reference list:

 

1. PL/SQL™ User's Guide and Reference (Contributing Author: Tom Portfolio)
2. http://psoug.org/reference/system_privs.html
3. Oracle для профессионалов.  Пер. с англ./ТомКайт- СПб.: ООО «ДиаСофтЮП», 2003. — 672 с.
4. ORACLE10 Server SQL Language Quick Reference (Contributing Author: Eric Armstrong)
5. ORACLE10 Server SQL Language Reference Manul (Contributing Author: Brian Linden)
6. Видео куры : Основы SQL и основые PL/SQL
7. ORACLE10 Server Application Developer's Guide (Contributing Authors: Eric Armstrong, Steven Bobrowski, John Frazzini,
8. Brian Linden, Maria Pratt)

¹ http://en.wikipedia.org/wiki/Oracle_Database