Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com
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
Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.
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.
Basically in isql we use browser and we can also use mouse here. But in sql we use terminal where we cannot use the mouse. Commands syntax are different from each other.
SUBSTR
datediff
Stored procedures prevent unauthorized access to data
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
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
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
gand maro...is the answer
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.
god only knows
In qlikview: SQL EXEC [dbo].[StoredProcedureName];