answersLogoWhite

0


Best Answer

In a programming language (such as Basic, C, COBOL, FORTRAN, and so on), you write lines of code that perform one operation after another until the program completes its tasks. The program may execute its lines of code in a linear sequence or loop to repeat some steps or branch to skip others. In any case, when writing a program in a procedural language, the programmer specifies what is to be done and how to do it.

SQL, on the other hand, is a query language in that you tell SQL what you want to do without specifying exactly how to accomplish the task. The DBMS decides the best way to perform the job.

Suppose, for example, that you have a CUSTOMER table, and you want a list of customers that owe you more than $1,000.00. You could tell the DBMS to generate the report with this SQL statement:

SELECT

NAME, ADDRESS, CITY, STATE, ZIP, PHONE_NUMBER,

BALANCE_DUE

FROM

CUSTOMER

WHERE

BALANCE_DUE > 1000.00

If writing a procedural program, you would have to write the control loop that reads each row (record) in the table, decides whether to print the values in the columns (fields), and moves on to the next row until it reaches the end of the table. In SQL, you specify only the data you want to see. The DBMS then examines the database and decides how best to fulfill your request.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

10y ago

Technology is developed for a particular purpose..For example, For development of web related applications, you have technology called "ASP.NET". For development of DataBase related applications, we have another technology called "ADO.NET" . But the Technology, doesn't offer any specific rules for writing the programs. But it offers some library. That's why, a technology cannot be implemented individually. It Requires a language for the rules to write the programs.

This answer is:
User Avatar

User Avatar

Sumon Kodali

Lvl 2
1y ago

In a programming language (such as Basic, C, COBOL, FORTRAN, and

so on), you write lines of code that perform one operation after

another until the program completes its tasks. The program may

execute its lines of code in a linear sequence or loop to repeat

some steps or branch to skip others. In any case, when writing a

program in a procedural language, the programmer specifies what is

to be done and how to do it.

SQL, on the other hand, is a query language in that you tell SQL

what you want to do without specifying exactly how to accomplish

the task. The DBMS decides the best way to perform the job.

Suppose, for example, that you have a CUSTOMER table, and you

want a list of customers that owe you more than $1,000.00. You

could tell the DBMS to generate the report with this SQL

statement:

SELECT

NAME, ADDRESS, CITY, STATE, ZIP, PHONE_NUMBER,

BALANCE_DUE

FROM

CUSTOMER

WHERE

BALANCE_DUE > 1000.00

If writing a procedural program, you would have to write the

control loop that reads each row (record) in the table, decides

whether to print the values in the columns (fields), and moves on

to the next row until it reaches the end of the table. In SQL, you

specify only the data you want to see. The DBMS then examines the

database and decides how best to fulfill your request.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Difference between programming language and query language?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

What is the difference between QBE and SQL?

Query by Example (QBE) is a database query language for relational databases. A QBE parser parses the search query and looks for the keywords. A more formal query string, in languages such as SQL, is then generated, which is finally executed. However, when compared with a formal query, the results in the QBE system will be more variable.SQL (Structured Query Language) SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs


What is a special language used to write computer programs?

SQL which stands for Structured Query Language The term you are looking for is programming language.


What is structure query language?

ADVANTAGES :)- 1.Its a high speed language. 2.There is not much of coding required like codind of programming languages. 3.Its emphasize on the concept of ORDBMS. Disadvantages:(- only 1 Its not v.user friendly!!


What kind of programming language is dbase?

It is a 3rd Generation or High Level language, specifically designed for working with databases, namely dBase ones. It works in a runtime environment so it is an interpreted language, but dBase does contain a compiler. It can also be compiled using a Clipper compiler.


Difference in hibernate 2.0 and hibernate 3.0?

Enhanced Hibernate Query Language Enhanced Hibernate Criteria Query API Enhanced support for queries expressed in the native SQL dialect of the database

Related questions

What is the difference between SQL and the other programming languages?

SQL is a query based language that is used to manipulate data stored in a database while other languages process data.


What is the difference between QBE and SQL?

Query by Example (QBE) is a database query language for relational databases. A QBE parser parses the search query and looks for the keywords. A more formal query string, in languages such as SQL, is then generated, which is finally executed. However, when compared with a formal query, the results in the QBE system will be more variable.SQL (Structured Query Language) SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs


What is the difference between sql and Microsoft Excel?

SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.


What are the differences between Oracle and SQL?

Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.


Can you create a program using SQL?

No you can't. SQL is not a programming language, so it doesn't create programs. It is a query language, and it creates queries. There is a difference. There are various things that programming languages have and that they can do, which would take a more detailed explanation to define. SQL is very limited in what it can do, being specifically designed to work with data and manipulate databases. It does not have the capabilities of a programming language. A query and a program are both a list of commands to do a task, but a program is far more extensive and can do far more things, and so it is very different to a query.


What are the differences between Oracle 10g and ms sql database?

Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.


What is a special language used to write computer programs?

SQL which stands for Structured Query Language The term you are looking for is programming language.


What is the difference between SQL2005 and Excel 2007?

SQL is Structured Query Language, and relates to databases. Excel is a spreadsheet application.


What do mean by query language and its needs?

Query Language is way for communicating from the database. It work as a interface between user and the Database. its not possible to generate a result from database without query language. Query language helps us to communicate with database.


What does the SQL distinct programming sentence stand for?

The SQL distinct programming sentence stand for Structural Query Language. It is a special interfacing program. Its means we need to learn this language like other language i.e C++.


Difference between SQL and OQL?

in some cease both are the same they use query language but in fact the out puts are very deference


Tell you very clearly what is the difference between sql and mysql?

SQL is a universal query language used to access relational data. MySQL is a database storage engine which utilizes the SQL query language as the means to interface with the data stored.