As we discussed in earlier tutorials that ng-model directive is used to define the model or variable for a HTML element to be used in AngularJS i.e. it binds the state of HTML element with model value. If the value HTML element changes, AngularJS automatically change the model value and vice-versa. Angularjs two way data … Read more
AngularJS Expressions: AngularJS expressions binds application data to HTML. AngularJS expressions can be written either inside double braces {{ expression }} or inside a directive ng-bind=”expression”. AngularJS expressions are like javascript expressions and outputs the result where they are used. Example Explanation: First include the AngularJS library in the application. The ng-app directive initializes the … Read more
First include the AngularJS library in the application. The ng-app directive initializes the application. The ng-model directive binds the state of the input text to the name variable. When we enter a value in name input box, the corresponding value will automatically updated in next line. Example: <html> <script src= "http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js"> </script> <body> <div ng-app=""> … Read more
Angularjs directives: AngularJS directives are used to extend the functionality of HTML elements. AngularJS are the special attributes starting with ng- prefix. Syntax: ng-xxxx = ‘value/name’ng-xxxx = ‘value/name’ Note: Some scenarios not need ‘value/name’, for these scenarios directive can be used as ‘ng-xxxx‘ or ng-xxxx=””. Commonly used AngularJS directives: ng-app – The ng-app directive initializes … Read more
Oracle pl sql package: A package is a schema object that groups logically related PL/SQL types, variables and subprograms. Parts of a package: 1. Package specification 2. Package body or definition Package specification: The package specification is the package interface which declares the types, variables, constants, exceptions, cursors and subprograms that can be referenced from … Read more
Oracle pl sql triggers: A database trigger is a stored program which is automatically fired or executed when some events occur. A trigger can execute in response to any of the following events: 1. A database manipulation (DML) statement like DELETE, INSERT or UPDATE. 2. A database definition (DDL) statement like CREATE, ALTER or DROP. … Read more
Exception: Exception refers to an exceptional event. Exception is an event that disrupts the normal flow of the program, during program execution. Pl sql exception handling: PL/SQL provides a mechanism to handle such exceptions so that normal flow of the program can be maintained. Types of exceptions: 1. System-defined exceptions. 2. User-defined exceptions. Syntax for … Read more
Context area: When processing an SQL statement, Oracle creates a temporary work area in the system memory which contains all the information needed for processing the statement known as context area. Cursor: A cursor is a pointer to context area i.e. Context area is controlled by the cursor. It is used to fetch and manipulate … Read more
Pl sql function: The pl sql function is a named PL/SQL block which performs one or more specific tasks and must returns a value. How to pass parameter in a function? We can use the below modes to pass the parameters in a function: IN-parameters: These parameters are the read-only parameters. Function cannot change the … Read more
Pl sql stored procedure: The pl sql stored procedure is a named PL/SQL block which performs one or more specific tasks. A pl sql stored procedure can be divided into two parts: Header and Body part. Header: The header part contains the name of the procedure and the parameters passed to the procedure. Body: The … Read more