How 2 Test PL/SQL with Oracle 10g | Part 1

In this post I'm going to show you how to test simple PL/SQL queries on an Oracle 10g database. Because this year I focus on databases I've decided to attend 'Database Management Systems' which is a lecutre at my university.

This lecture or better the responsible institute provides an Oracle 10g database for all students who'd like to complete the corresponding exercise. Here is the description of the first exercise. I had to design a (small) complete database including EER-Diagram, relations, CREATE TABLE, DROP TABLE and INSERT INTO statements.

So, if you already have designed the EER-Diagram and corresponding database-relations you have to implement the necessary sql-files and execute them on the server which is provided by the lecture's institute. I focus on showing you how to test under Windows Vista.

The first step I had to do I had to download a ssh-client for my OS to connect to the universities' server. I chose Putty because I'm a experienced on using this client. After I've successfully installed Putty I tried to connect to the server by opening a new session.



I've entered my creds and finally I successfully was connected.



Then I've create a test directory where I wrote my first create_table.sql file with vim.



In the next step I've started a new Putty-Connection to run the table script by entering 'slqp' on the command-line. Again I had to enter my creds for this SQLPlus session.



The first command which you should enter is the 'SET SERVEROUTPUT ON' command to get the corresponding output of the server after you have executed a query.



Then I've testet my create_table.sql file by typing 'start PATH_TO_FILE/create_table.sql'. If your sql-file successfully executed you can type 'exit' to exit the SQLPlus session.



To be continued ...

IBM WAS Education Assistant

In this post I'd like to reference a very important Web-Site if you are interested in IBM's WebSpere Application Server. This site is called the IBM Education Assistant where you can find a lot of good ressources about the Application Server in a variety of versions (5, 6, + fixpackages, ...).

In addition you'll find a lot of good screencasts and slides which gives you a pretty good overview about this product. A few posts ago I showed off a little by posting about my IBM Certificate for the IBM WAS 6.1 and if you are interested in what I've learned in that IBM training, go to the Education Assistant and watch all the screencasts which you can find under 'WebSphere Application Server 6 / V6.1'



Cheers

Java Rules Engines | Words and Phrases

This Posting is about the book which I'm currently reading. (Java Rules Engines) The Post summarizes some words or phrases which were new to me and I'd like to remember them. Because I even didn't know those in german I'm going to sum them up in german.

Kapitel 1 Buch Seite 15: virale Ansätze.

Ein Viral ist ein Werbespot, der eigens für das Internet produziert wird. Sein Name leitet sich ab von der Werbeform, innerhalb derer er konzipiert und eingesetzt wird, dem viralen Marketing

Kapitel 1 Buch Seite 15: kognitive Fähigkeiten:

Der Begriff kognitiv stammt aus der Psychologie und bezeichnet solche Funktionen des Menschen, die mit Wahrnehmung, Lernen, Erinnern und Denken, also der menschlichen Erkenntnis- und Informationsverarbeitung in Zusammenhang stehen.

Kapitel 1 Buch Seite 20: Konsekutivsätze:

Das Adjektiv konsekutiv bedeutet soviel wie zeitlich folgend, von einer vorherigen Gegebenheit abhängig.

Kapitel 1 Buch Seite 23: Omnipotente Schnittstelle:

Mit Allmacht, Allmächtigkeit oder Omnipotenz wird die Fähigkeit eines Wesens bezeichnet, jedes Ereignis auch jenseits naturwissenschaftlicher Erklärbarkeit in Gang zu setzen oder zu beeinflussen.

Kapitel 1 Buch Seite 25: Profan:

Es bezeichnet im eigentlichen Sinne die Eigenschaft von Objekten oder Handlungen, die nicht im Zusammenhang mit einem Kult stehen, die keine rituelle oder religiöse Bedeutung tragen und denen keine magischen Eigenschaften und Wirkungen zugesprochen werden.

To be continued...