Unfortunately, the official specifications are not freely available (ANSI makes them available for purchase). However, there are books - such as SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer - which give a comprehensive overview of the standard, including coverage of stored procedures.

In the proc table of the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE FUNCTION to obtain information about stored functions, and SHOW CREATE PROCEDURE to obtain information about stored procedures. See Section 13.5.4.8, "SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax", for more information about these statements. You can also query the ROUTINES table in the INFORMATION_SCHEMA database - see Section 22.

Yes you can, although you will have to manually construct every map request and process every map response your program received from MapViewer server. MapViewer server communicates using the standard HTTP protocol. The map request and response are encoded in XML, whose DTD is documented in the MapViewer User's Guide. As a result, as long as your program can open a URL connection and send/receive data using HTTP Post, it can then talk to MapViewer.

Both PL/SQL and Java can be used to create Oracle stored procedures and triggers. This often leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour of Java?". Many Oracle applications are based on PL/SQL and it would be difficult of Oracle to ever desupport PL/SQL. In fact, all indications are that PL/SQL still has a bright future ahead of it. Many enhancements are still being made to PL/SQL.

Most likely you're trying to debug on a version of VS that doesn't support SQL debugging. You need Visual Studio Professional Edition or higher. Credentials used to run VS and to make connection to SQL Server must have SA role e.g. part of Administrators group on SQL Server box. Go to https://connect.microsoft.com/site/sitehome.aspx?SiteID=210&wa=wsignin1.0 and click on Submit Feedback and follow steps to file a bug/suggestion against VS debugger.

This is a privilege issue.You will probably get the error 1044 "Access denied ..." or 1370 "Alter routine command denied to user ...". ...

Latest Answer: Hi All,I am new to this community. It seems the question is related to Begin End block of PL/SQL. Se... Latest Answer: You must be speaking about PLS_INTEGER. PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER... Latest Answer: DESC will display the values in DESCending order when used in an ORDER BY clause.For example:SELECT ... Latest Answer: In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping c..

By default, you put an exception handler at the end of a subprogram to handle exceptions that are raised anywhere inside the subprogram. To continue executing from the spot where an exception happens, enclose the code that might raise an exception inside another BEGIN-END block with its own exception handler. For example, you might put separate BEGIN-END blocks around groups of SQL statements that might raise NO_DATA_FOUND, or around arithmetic operations that might raise DIVIDE_BY_ZERO.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements. PL/SQL is a normal programming language that includes all the features of most other programming languages.

You need to add "setenv EPC_DISABLED TRUE" to your Oracle startup script or profile. This is a problem in the server. How can I see all my tables? SQL> select table_name from tabs; or SQL> select table_name from user_tables; (tabs is actually a public synonym for user_tables).

Yes. For a database named dbname, use this query on the INFORMATION_SCHEMA.ROUTINES table: SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='dbname'; The body of a stored routine can be viewed using SHOW CREATE FUNCTION (for a stored function) or SHOW CREATE PROCEDURE (for a stored procedure). See Section 13.5.4.8, "SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax", for more information.

Yes. If a database schema has become inconsistent due to the use of sp_rename, and a stored procedure or a function definition refers to a different name from what is in the system tables, SQL Compare 6 automatically fixes these inconsistencies.

I have used Weblogic's type 2 JDBC driver (formerly known as FastForward) on two big projects. Oracle's type 4 JDBC driver was crashing against a big query...and type 2 couldn't be used with M$ VM. Weblogic bundles these drivers with Tengah but you can ask them just for the JDBC drivers.... I had used Openlink's type 3 JDBC drivers too (about 2.5+ years ago) but I didn't like them much. PS: Check out these links for more info:

A piece of native C-code that translates a JDBC call to an ODBC call. Use this driver for development, not for industrial-strength application environments. Note that you have to have an ODBC database driver manager + an ODBC database driver installed on the server in addition to the JDBC/ODBC bridge. A piece of native C-code that translates a java JDBC call to a native database call level API. Use this driver for development and deployment.

Not in MySQL 5.1. We intend to implement the SQL standard SIGNAL and RESIGNAL statements in a future MySQL release.

MySQL implements HANDLER definitions according to the SQL standard. See Section 18.2.8.2, "DECLARE Handlers", for details.

Latest Answer: SQL is a structured query language.Used to perform operations such as retrieval,updations,insertions... How can I use the bind variable in a report to create an output file. For example I give the starting... What is the difference between IS/AS while creating a procedure ?i.e Create or Replace procedure is/as... How to write a query or procedure or function to retrieve all the tables from database where the table...