What Is SQL (Structured Query Language)? Many people who already know what it is Structured Query Language (SQL). Understanding Structured Query Language (SQL) is a high language-oriented, group data (tables) and non-procedure for a relational database. Why are said to be a high level language? because SQL uses the English language, why say oriented group table? because unlike other languages ​​that only have the capability to record only. And why are non-procedural? because it give us what we are looking for.
SQL (Structured Query Language) created in the 1970s by IBM in San Jose Research Laboratories. SQL standardization started in 1986 from the American National Standards Institute (ANSI) and in 1987 by the International Standards Organization (ISO).

SQL language created to define and manipulate objects and data in the database (database). It becomes something that is important because:
  • is a portable that can be directly used on the PC though made on minicomputers.
  • procedure language database created on a PC, can be used to retrieve data in the same minicomputer because of its language.

Tools to run the command Structured Query Language (SQL), among others:
  • SQL Plus (Windows), is part of Oracle Database products. This tool can be run on Microsoft XP/98/2000. For how to run this product: Start -> Programs -> Oracle for windows NT -> SQL Plus
  • SQL Plus (DOS), how to execute SQL commands by using cmd or DOS. How to run it: Start -> Run, type cmd. Once open cmd, then type in sql plus enter. Enter your user ID and password.
  • SVRMGRL (DOS), the same as the SQL Plus DOS, distinguished only way to run it. How to run it: Start -> Run. Type cmd. When cmd is already open, type and enter svrmgrl. After that, type connect internal and fill passwords.
  • Open Database Connectivity (ODBC), is the standardization of various kinds of databases that can be run by other applications. How to run it: Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources. Press the Add button, then select the driver database searchable.
  • Another tool that can be used, such as: Toad, Quest Software.

That was a brief description of What Is SQL (Structured Query Language). If there are errors or omissions please justified or added. May be useful.

In this post, i will dicuss about PL/SQL Set Serveroutput On. The simplest example in the manufacture of PL / SQL is a text on the screen displays the SQL * Plus you.

Here is PL/SQL Set Serveroutput On sample:

BEGIN

    dbms_output.put_line ('I Learning PL / SQL');

END;

When finished writing PL / SQL above, then to run it write slash mark (/) under the heading END.
And so far you only get the message in the form of PL / SQL procedure successfully completed which indicate that the PL / SQL that you buata can run properly. But you have not seen the results of the PL / SQL that you create. To be able to see the results of PL / SQL that you created, then you should set the system into a state SERVEROUTPUT On by writing the following syntax.

SERVEROUTPUT ON SET
This is done because by default every time the SQL * Plus is started, the system variable SERVEROUTPUT into Off state. If you've set the variable SERVEROUTPUT, try running back to PL / SQL you did by writing the slash (/).

That was a brief explanation about PL/SQL Set Serveroutput On. If there are errors or omissions please justified or added. May be usefull.

In PL/SQL there is 3 loop. It is a For loop, while loop, and do-while. This post, i will discuss about PL/SQL While-Loop. The structure of this loop, the program will enter the loop body is given only if the condition is true. Checking process occurs when the program entered the loop body. Almost every language has a procedural structure of this loop. General syntax:

WHILE condition LOOP

             statemen_1;

             ...

END LOOP;

example: display the text I Learning PL / SQL.

DECLARE

             Integer J;

BEGIN

             A: = 1;

             WHILE (J <= 10) LOOP

                         dbms_output.put_line ('I Learning PL / SQL');

                         J: = J +1;

             END LOOP;

END:

ket:

before entering into the body of loop variable J has a value which is 1, then be checked against that value is less than or equal to 10 or not. If yes, then the program enters the process of repetition. And vice versa. Since the condition 1 <= 10 TRUE, the statements in row 6 will be executed. Then, the value of J will increase to 2 because the statements in row 7. An iterative process will stop if the variable A is worth 11 because the condition J <= 10 was worth FALSE.

example: calculate the value of powers of 2 to the power 6

DECLARE

             BIL integer: = 2;

             RESULTS integer: = 1;

             Integer K;

BEGIN

             K: = 0;

             WHILE K <6 LOOP

                         RESULT: = RESULT * BIL;

                         K: = K +1;

             END LOOP;

             dbms_output.put_line ('Results from the 2 ^ 6 =' | | RESULT);

END;

example: 5x10 multiplication without multiplication operator (*).

DECLARE

             BIL integer: = 5;

             RESULTS integer: = 0;

             K integer: = 1;

BEGIN

             LIMITS: = BIL;

             WHILE K <= 10 LOOP

                         RESULT: = RESULT + BIL;

                         K: = K +1;

             END LOOP;

             dbms_output.put_line ('Results from 5 X 10 =' | | RESULT);

END;

That was a brief explanation about PL/SQL While-Loop. If there are errors or omissions please justified or added. Hope usefull.

In the world of PL / SQL functions or there are several ways to perform a desired command by a system manufacturer. One of them which I will discuss in my post this time of Procedure.

Procedure is a PL / SQL block where there is no returned value. So, inside the block there is only a command only. Where the execution takes its own syntax to run it.

The following procedure structure PL / SQL in general:

CREATE OR REPLACE PROCEDURE nama_procedure (tipe_data1 parameter1, parameter2 tipe_data2. Etc. ..) IS

BEGIN

        ...

Exception

        ...

END;

For more details, take a look at the example below:

CREATE OR REPLACE PROCEDURE IS number
    A NUMBER (2);
    FRI VARCHAR (20);
BEGIN
    A: = 0;
    SELECT COUNT (*) INTO A FROM TAB;
        IF A = 10 THEN FRI: = 'TEN';
           ELSIF FRI THEN A = 11: = 'ELEVEN';
           ELSIF FRI THEN A = 12: = 'TWELVE';
           ELSIF FRI THEN A = 13: = 'THIRTEEN';
           ELSIF FRI THEN A = 14: = 'Fourteen';
           ELSIF FRI THEN A = 15: = 'FIFTEEN';
        ELSE
           FRI: = 'A LOT';
END IF;
DBMS_OUTPUT.PUT_LINE ('Number of table' | | FRI);
END;

In PL / SQL block above, the procedure has a number of names, with A and FRI with each data type and length (length). In line 5, the parameter J is defined with a value of 0. While the commands contained in blocks, count the rows from the table TAB (row 6). In PL / SQL block is contained branching.

As for running the block:

in the SQL editor = exec procedure name (parameter1, parameter2, etc. ..);

                               exec sum (J, FRI);

Here was a brief description of How to create a procedure in PL / SQL. If there are shortcomings or mistakes please add or justified. May be useful ..


Information systems are not made arbitrarily. In making the necessary principles and mature concept that the system is working as expected in practice. Not infrequently a system when applied to raw information, the absence of the principle of the right to good information system creation. Kalli on this post, I will discuss the principles of a good system.

Here are some principles of a good system:

1. Availability, include:
Documentation of complete data, where every business activity can be recorded in an information system. Minimize system failures, prevent the system can run in line with expectations.
2. Security
Giving a password, one form of security of a system, required security password to prevent misuse of the data.
Pposisi safe computer, it is more directed on computer and network layout.
Put safety alarm, to prevent hardware theft. Such as: monitors, cpou, etc..
Data control, monitoring data regularly can reduce the risk of security problems of data stored on a system.
3. Can be maintained
Performance measurement system and the periodic review system, these two things are related. Because a review of the system can be used routinely to monitor the data as well as measure the performance of the running system. So the data information system management knows what to do with the system going forward.
4. Integrity
Verification of the data, the process of checking the data when the data is entered into an information to come out. Verification of the data takes time and effort, which is conducted by the management system.
Duplicate data checking, to reduce data redundancy (duplicate data) needs to be done gradually. Can also be categorized as a data control. It's just that it aims to manage database systems.

That was a brief description of the principle of a good system. Hope it helps and if there is an error can be input via the comments below. Thank you.


Systems definition is a series of two or more components that are connected to achieve a goal. Meanwhile, informations definition is data that has been organized and processed to provide meaning

Here are some definitions of Information Systems:
• A man-made system consisting of components within the organization to achieve a goal which presents information
• A set of organizational procedures when implemented will provide information for decision makers and / or to control the organization
• A system in an organization that brings transaction processing needs, support operations, managerial, and strategic activities of an organization and provides a certain outsiders with diperluka reports.

As an example we take Management Information System. Management Information System is an information system. In it there are some administrative systems or commonly referred to as sub-systems. Examples of Management Information System: attendance system, appraisal system, payroll system, promotion system, etc.. Another example is the Information Systems Executive Information Systems, Management Information Systems and Accounting Information Systems.

In the manufacturing process, information system planning should be made in advance so that the system can be used and will be made in accordance with the wishes of the user. So in making the necessary system Project Management Information System. In which there are methods or steps for making information systems can benefit everyone, and reduce threats to information systems.

Components of the Information System:
• instructions
• The fact that the stored
• Humans
• Computer
• Procedure


At this time I would like to explain the meaning or what is information. What is the meaning of information? Information is data that has been processed so that it can be useful for anyone in need. Information can be recorded or transmitted. The experts have many other meanings of information. Information can be regarded as knowledge gained from study, experience or instruction. However, this term has many meanings depending on the context.

In particular some knowledge of the events that have been collected or from the news can also be regarded as information. In computer science, information is data that is stored, processed or transmitted. The experts examined the concept of information as knowledge gained from study, experience or instruction.

Meaning or definition of the other information is data that has been given meaning. For example, the form of a spreadsheet document (Ms.Excel) is often used to create information from data therein. Income statement and balance sheet is one form of information, while the figures contained therein is data that has been processed so that it becomes useful for anyone who can use it.

The types of informations:

Based delivery:
  • Information provided periodically
  • The information provided for the sudden
  • The information provided at any time
  • Exempt information
  • Information obtained on request


Based on usability:

  • Informations that adds to the knowledge, for example: events, education, activities celebrities.
  • Informations that teaches the reader (educational information), such as paper describes how to raise ducks, articles about how to build friendships, and others.
  • Informations based on the presentation format, information that is distinguished by the form of presentation of the information. For example: the information in writing (news, articles, essays, reviews, columns, editorials, etc.),


The characteristics of an information:
  • The latest,
  • Right on time,
  • Relevant,
  • Consistent.
  • As for the functionality, information has several kinds of functions, including:
  • Improve the knowledge or ability of the user,
  • Reduce uncertainty in the decision-making process,
  • Describe the state of something or events that occur.


That was a glimpse of the meaning or definition of What is information. If there are mistakes or flaws can be added in the comments field. May be useful.

Related Posts Plugin for WordPress, Blogger...