Visual Basic is a third-generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model first released in 1991. Microsoft intends Visual Basic to be relatively easy to learn and use. A programmer can create an application using the components provided by the Visual Basic program itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations. Programmers can not only create simple GUI applications, but to also develop complex applications. Programming in VB is a combination of visually arranging components or controls on a form, specifying attributes and actions for those components, and writing additional lines of code for more functionality. Forms are created using drag-and-drop techniques. A tool is used to place controls (e.g., text boxes, buttons, etc.) on the form (window). Controls have attributes and event handlers associated with them. Default values are provided when the control is created, but may be changed by the programmer. Many attribute values can be modified during run time based on user actions or changes in the environment, providing a dynamic application.
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. An Oracle database system—identified by an alphanumeric system identifier or SID __ comprises at least one instance of the application, along with data storage. The Oracle DBMS can store and execute stored procedures and functions within itself. Oracle database management tracks its computer data storage with the help of information stored in the
SYSTEM tablespace. The
SYSTEM tablespace contains the data dictionary—and often (by default) indexes and clusters. Each Oracle instance uses a System Global Area or SGA—a shared-memory area—to store its data and control-information.