0
Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?
SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
Difference between sql function and sql procedure?
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com
What sql function returns the numeric position of a named string?
SUBSTR
What are the main function in sql?
SQL (Structured Query Language) is a language used in a SQL server to manage data (Query the data, insert, Update, Delete) as well as perform data manipulation (calculations, etc)
What is UDT and SQL?
UDT stands for User-Defined Types, which allow users to define their own data types in programming languages like C++. SQL (Structured Query Language) is a standard language for interacting with relational databases, used for tasks like querying data, updating records, and defining database structures.
What is the function of an SQL server replication?
The function of an SQL server replication is to restrict the control that a user has. Limiting these possibilities ensures safety on networks and with untrusted users.
Is SQL An application to manage Data in a database?
SQL is a language broad term to define a type of database. More specific ones are My SQL (open source) and MicroSoft SQL
Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?
SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S
What is operator function?
An operator function implements a particular operator symbol. The database server provides special SQL-invoked functions, called operator functions, that implement operators. An operator function processes one to three arguments and returns a value. When an SQL statement contains an operator, the database server automatically invokes the associated operator function. The association between an operator and an operator function is called operator binding. You can overload an operator function to provide the operator for a UDT. The SQL user can then use the operator with the UDT as well as with the built-in data types. When an SQL statement contains an operator, the database server automatically invokes the associated operator function.
How do you recover database file using sql server?
A SQL recovery tool (see below) will help you repair corrupted .mdf files, tables, views, stored procedures, rules, defaults, user defined data types and triggers from Microsoft SQL server database & effectively recover large SQL Server database. Recover sql server databases thanks to programmed method I would recommend you next utility
What is a character function in SQL?
Spongebob
In SQL what is the function of the union operator?
In SQL, the function of the union operator is to combine the result of two or more select-statements. The union operator is a very useful tool when coding SQL.
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
How do you run sql on terminal in linux os?
mysql -u user -p -e 'SQL Query' database
What are the differences between sql and mysql?
SQL is short for Structured Query Language, and MySQL is a database management system, like SQL Server 2005, Oracle.An example would be other programming languages like BASIC and QBASIC where BASIC is the generic term for the BASIC programming language and QBASIC is Microsoft's version (quick BASIC) and TURBO BASIC was Borlands version.oracle supports the user defined datatypes,where as mysql not support all these types of datatypes, like user defined , and cursors like these stuff;;
SQL statements that define the tables in a database are referred to as?
DDL Statments
