Database Programming


Top Answer
User Avatar
Wiki User
Answered 2008-05-19 20:29:50

ANSI SQL is the American National Standards Institute standardized Structured Query Language. ANSI SQL is the base for several different SQL languages such as T-SQL and PL/SQL. ANSI SQL is used to Create, Alter, and View data stored within a database. For more information about ANSI: For more information about SQL:

User Avatar

Your Answer

Still Have Questions?

Related Questions

What is the difference between sql and an sql server?

SQL is an abbreviation for Structured Query Language. SQL is a means to request data from a database. SQL is a standards based langage that has many versions approved by the American National Standards Institute (ANSI). There are many versions of ANSI-SQL and most databases support specific versions of ANSI-SQL. SQL Server is a database management system that was originally created by Sybase. Microsoft bought the rights from Sybase to market their own version of SQL Server on the Microsoft Windows operating system. Sybase still has versions of SQL Server on other operating systems. When people refer to SQL Server, they typically mean "Microsoft SQL Server." Microsoft SQL Server is a database management system (DBMS) that utilizes SQL (or more specifically Transact-SQL, or T-SQL) as a means to extract data from it's database tables.

What is SQL and iSQLplus commands?

sql is language based on ANSI where keywords cannot be abbreviated. isqlplus is and environment and oracle proprietary where keywords cannot be abbreviated.

What database functions does MS Access support?

MS Access supports most of the ANSI-92 SQL subset.

What are the differences between a sql server dba and a sql dba?

The term SQL alone implies Structured Query Language as per the ANSI standard. Every Database Management System (DBMS) has its own "software" that makes it work. That being said, the term "SQL DBA" alone does not make any sense without mentioning the vendor specific DBMS you are managing. So, an SQL Server DBA is an administrator of Microsoft's SQL Server.

Who manufactures SQL servers and what is this DBMS' current version number?

An SQL server is any server that implements the Structured Query Language. SQL is the standard of the American National Standards Institute (ANSI) and the International Organization for Standardization (IOS). It was developed by IBM in the 1970s. It appears the latest revision was made in 2014. No one company manufactures SQL servers.

What training is needed to work with SQL databases?

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the interpreter will support everything covered in this course.

Can any one reply to my query that what is the difference between sqlplus and isql?

SQLSQL is a language that can communicate with Oracle server to access the data.It is based on ANSI standards.There is no continuation character.Keywords cannot be abbreviated.Use functions to manipulate the data.SQL*PLUSIt recognizes SQL statement and sends them to the server.Is an Oracle proprietary.There is a continuation character.Keywords can be abbreviated.Use commands to manipulate the data.

What is ansi 150?

Ansi 150 is a pressure grade of flange ie. Ansi #150 Flange. For steel flanges this is specified by ANSI B16.5.

What is difference between oracle and sql?

The Oracle RDBMS system primarily provides programming access via 2 languages:SQL - the standard language for searching and updating a relational database. Oracle provides various extensions/customizations to the standard ANSI SQL language. I wouldn't call SQL a programming language exactly, since it's only good for defining database objects (e.g. tables), then querying and updating them.PL/SQL - Oracle's Procedural Language for SQL (hence the name PL/SQL). This is a fairly complete procedural programming language (including limited object-oriented features), primarily used to manipulate the data you've accessed via SQL.Additionally, Oracle support SQL access via Java (notJavascript).

What is embedded sql?

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as: C/C++, COBOL and Fortran.The ANSI SQL standards committee defined the embedded SQL standard in two steps: a formalism called Module Languagewas defined, then the embedded SQL standard was derived from Module Language.[1] The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred to as the host language. A popular host language is C. The mixed C and embedded SQL is called Pro*C in Oracle and Sybase database management systems. In the PostgreSQL database management system this precompiler is called ECPG. Other embedded SQL precompilers are Pro*Ada, Pro*COBOL, Pro*FORTRAN, Pro*Pascal, and Pro*PL/I.

How do you write the syntax to retrieve records with last name starting with P in SQL?

The SQL you need is something like what I wrote below, although the wild card character (% or *) may depend on the ANSI standard of your database. Select * From tablename where LastName Like 'P%' Select * From tablename where LastName Like 'P*'

Is the primary key a field that uniquely identifies each record?

Yes, the primary key is a field that uniquely identifies each record. The ANSI SQL Standard defines the primary keys through the PK restraint.

How many type of SQL?

native sql,cognos sql,pass-through sql

Can I programming with Ansi c plus plus with w2000p?

Yes, if you have an ANSI C++ compiler. Most modern compilers are ANSI, and are capable of suppressing non-ANSI code, using a compiler option.

What do you mean sql client?

sql client is a client of sql

What is an example of a standard query language used in relational databases?

The standard query language for relational databases, as adopted by the American National Standards Institute (ANSI), is SQL, which is generally understood to be an abbreviation for "structured query language."

Difference between traditional c and ansi c?

C is C and ANSI C is ANSI C the best definition for all time.

Where could someone find an SQL formatter?

One can find an SQL formatter from: SQL Format, Free Formatter, Poor SQL, T-SQL Tidy, Stack Overflow, SQL Inform, Apex SQL, SQL Parser, Red Gate software, to name a few.

What does ANSI means and stands for?

ANSI stands for "American National Standars Institute"

When was Ansi Agolli born?

Ansi Agolli was born on 1982-10-11.

When was Ansi Nika born?

Ansi Nika was born on 1990-08-22.

What is the difference between T-sql and sql?

T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.

What is database and how is using in C?

A database is a type of application that stores information in tables, which are made of columns and rows, such that certain terms can be fed to it and related information fed back out. C can be used to make a database, but inside the database, c can't be used: in generally a set of specifications called "SQL" and "ansi SQL" are used to describe how to get the data back out of the database.

What is called the standard database query language supported by all relational databases?

SQL stands for Structured Query Language. It is fairly standard but implementations generally have non-standard parts. These are usually to do with how data storage is specified, options to aid performance and extra things thought useful that aren't specified int the ANSI standard specification for SQL.

What is the dimension difference between ANSI 300 Flange and PN16 Flange?

PN 20 is equal to ANSI 150 & ANSI 300 equals PN 50.

Still have questions?