answersLogoWhite

0

Why sql is non procedural language?

Updated: 3/5/2024
User Avatar

PritamPaul

Lvl 1
12y ago

Best Answer

non-procedural language in which you can communicate tasks to the compute using simple commands.

A procedural language is one in which you must give the computer step by step

instructions for accomplishing a task

User Avatar

Wiki User

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

Wiki User

9y ago

SQL is a nonprocedural language because the program's actions are pre-defined instead of having to be manually done. This is also known as event-driven.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why sql is non procedural language?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

What statement belong in a procedural languages but not in a non procedural language?

Assignment operator


Is the java is procedural language?

Java is an Object Oriented language not a procedural language


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 are some examples of procedural and non procedural programming?

Procedural programming is classic programming where the program language is used to tell the computer EXACTLY what do do - step by step. Examples are Assembler, Fortran, Cobol, C, etc etc. Very detailed, very difficult and time consuming to write, but very efficient from the computers point of view. NON-procedural programming is where you tell the computer what you want, and it figures out how to get it. Non/P programming is often used for database manipulations, like SQL, Visual Basic, etc etc. A SQL command like "Select name, address, city, state, zip order by zip" is non procedural. That one line replaces dozens, or hundred of lines, that would be needed to do the same thing in Cobol or C to get data out of a database.


What is the purpose of SQLPLUS?

SQLPLUS, also written as SQL+ or SQL*Plus and pronounced "sequel plus" is a type of non-compiled (scripted) computer language that is used to write programs for accessing relational databases. The SQL acronym stands for "Simple Query Language" or "Structured Query Language" depending on who you ask. The original language developed by IBM was called SEQUEL (Structured English Query Language) but later changed to SQL due to the name SEQUEL being the trademark of another company. SQL+ is a variant of the original language developed by Oracle Corporation.

Related questions

What is sql and plsql?

SQL stands for Structured Query Language, and is a computer language designed for writing data manipulation or data management statements against a relational database. PL/SQL stands for Procedural Language/Structured Query Language which is Oracle's proprietary procedural extensions to the SQL language.


What is PLSQL?

The Oracle Corporation's application development language is PL/SQL. It is a superset of SQL that uses standard programming-language to supplement the SQL. PL/SQL stands for Procedural Language/Structured Query Language.


What is Procedural query language?

A procedural language is nothing but what we call relational algebra. Procedural language is just like SQL but with different syntax. In Procedural language for "Select" we use projection and for "where" clause we use selection.


Why 4gl is called non procedural language?

because it is non-procedural language, in this language object oriented languages are use to develop software application.


What is the difference between program language and procedural language?

programming language is of two type 1. procedural programming language 2.non procrdural programming language .. ----non procedural programming language means that which relates with the real world.. for example-oops oops is a non procedural programming language because it relates to the object and object relate to the natural or real world where as that languge which does not belong to the real world is known as procedural language


What statement belong in a procedural languages but not in a non procedural language?

Assignment operator


Pl sql programs executes in sql server?

PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.


Who invented Non-procedural language?

black people


Difference between procedural and nonprocedural language?

Non.


Describe Procedural query language and non procedural query language in DBMS?

A query language is a language in which a user requests information from the database. These languages are usually on a level higher than that of a standardprogramming language. Query languages can be categorized as either procedural or non procedural.In a procedural language, the user instructs the system toperform a sequence of operations on the database to compute the desired result.In a non procedural language, the user describes the desired information withoutgiving a specific procedure for obtaining that information.


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 the difference between a procedural language and declarative language?

Procedural is nothing but just using procedures to instrct te machine. The procedures provides a level of abstraction here. Declarative means to program without specifying the steps involved clearly. It allows us not give the control flow. ex - SQL is declarative as it does not need the control flow to be implemented. SQL is also procedural as it works on procedure names that are predefined.