Sponsored Links
More Free Tutorials
Oracle8 Server Distributed Database Systems
News
Keywords
Operators, boolean operators, logical operators, relational operators, query, report, query by example, SQL, structured query language, search operators, wildcards, criteria
Links and Tutorials
Knowledge Management: Emerging perspectives
Knowledge Management Network (including virtual library)
Sponsored Links
Operators
Queries can be designed as QBE (query by example) but can also include operators as listed below in the table. There are seven basic mathematical operators. These are also known as arithmetic operators becasue they are used for performing arithmetic calculations:
Examples
The following operations are carried out on fileds but they can also be carried out using a combination of fields, numbers or a variable.
[UnitCost] - [Discount]
[UnitCost] + [TransportCost]
[UnitCost] * [NumberofItems] + [TransportCost]
[GrossAmount] - ([GrossAmount]*[Discount])
More On Distributed Databases: Distributed Databases,
Related Topics (Information Systems) : DBMS, The 5 Types of Information Systems, Expert Systems, TPS, DSS, ES, MIS, OAS, Characteristics, computerised methods, non-computerised methods, flat file databases, relational databases, data modelling, URLs, storyboards, searching, HTML, backups, security methods, encryption, firewalls, virus' and virus scanners, passwords and security levels, social and ethical issues, data accuracy, data integrity, data validation, data bias, data reliability, privacy, ownership and control of data, access to data, data warehousing, data mining, freedom of information, acknowledgement of data sources, issues related to new trends, sequential access, direct access, distributed databases, storage media, querying, operators, wildcards, sorting, SQL, biometrics and ethical issues, face recognition
See Also: Knowledge Management, data mining,Information systems