Technology Questions

Various activities in SAP MM are : Inventory, Warehouse, Purchasing, Vendor evolution, Invoice varification, etc.

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

It generates a bind run-unit and binds all the records for the sub-schema the program is referencing.

Aggregate functions in SQL are used to perform calculation on data. These functions are inbuilt in SQL and return a single value.

SUM( )

SUM function returns the sum or addition of all NOT NULL values of a column. For e.g. I have a Table employee with the fields id, name, salary and I want the sum of all salaries, I can use SUM function as shown
SELECT SUM(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 63,000

AVG( )

 
AVG function returns the average of all NOT NULL values of a column. For e.g. I have a Table employee with the fields id, name, salary and I want the average of all salaries, I can use AVG function as shown
SELECT AVG(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 21,000

COUNT( )

COUNT function returns the number of rows or values of a table. For e.g. I have a Table employee with the fields id, name, salary and I want the count of all rows, I can use COUNT function as shown
SELECT COUNT(*) from employee;

Max ( ) and Min ( )

MAX function returns the largest value of a column in a table. For e.g. I have a Table employee with the fields id, name, salary and I want the maximum salary of an employee, I can use MAX function as shown
SELECT MAX(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 22,000

MIN function returns the smallest value of a column in a table. For e.g. I have a Table employee with the fields id, name, salary and I want the minimun salary of an employee, I can use MIN function as shown
SELECT MIN(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 20,000

AngularJS is a framework to build the large scale and high performance web application while keeping them as easy-to-maintain. These are the features of AngularJS framework.

AngularJS is a powerful Script based on JavaScript development framework to Implement RICH Internet Application (RIA).

AngularJS is a developers options to write client side application (using JavaScript) in a clean MVC (Model View Controller) side.

Application are written in AngularJS is also cross-browser compliant. AngularJS automatically handles JavaScript code suitable for any browser.

AngularJS is an open source, completely free, and used by large number of developers around the world. It is licensed under the Apache License version 2.0.

Templates are the rendered view with information from the controller and model. These can be a single file like index.html or multiple views in one page using "partials".

- Rename : It is a permanent name provided to a table or column.
- Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement.