PL/SQL lets you issue a query and return a result set using a cursor variable, also known as a REF CURSOR. See "Using Cursor Variables (REF CURSORs)".

It's a subset of Visual Basic 6. We've left out some of the advanced features to make it easier to get started with and use. The result is still a very rich and complete language. See the NS Basic/Desktop Specifications for a list of statements and functions supported. It's pretty easy to take most VB projects and convert them to NS Basic/Desktop. Compared to VB.NET, NS Basic/Desktop is much easier to get started with. It also does not have the runtime enviroment requirements that .NET has. See similar questions...

I am using referral (referer) protection however, with MPEGS, WMV's and pdf's it does not work - users are denied access, and with printing CSS I have the same problem. See similar questions...

When VB source is compiled to Native Code the result is x86 machine code and in the process the VB compiler with its various code optimisation features erases much of the structure of the high level Basic language. It's a formidable job to try to reverse engineer this x86 code back into VB code and it's not at all clear to us that it's possible to automate the reversing process. See similar questions...

Many programmers code their Java classes (see #9 above) using the Editor that is supplied with their Operating Systme (I use Windows Notepad myself). The Java Development Kit (JDK) that you download from Sun Microsystems does not come with an IDE per se--but you can download one for free from Sun called Forte, and there are some other free ones available. In addition, there are other IDE's available for purchase. See similar questions...

Those acronyms refer to various features such as programming languages, databases, etc. that might be available with a hosting plan. Please check out our Glossary for definitions. See similar questions...

Assuming that you have successfully installed C-Sharpener For VB, the menu option should automatically appear. If it doesn't appear, then try the following: Turn on the checkbox to the left of C-Sharpener For VB and click the OK button. The menu option should now appear. See similar questions...

J. Henshaw asks "Is it possible to run both VB6 and VB.Net on the same machine,or do I have to remove VB6 to be able to use VB.NET", and the answer is a definite yes. You can run them both on the same machine. Many people, including myself, run VB6 on the same machine as their installation of Visual Basic .NET. If you look at this KB article from Microsoft Support, you will even see that it recommended to run VB6 and VB.NET on the same machine when upgrading projects from one to another. See similar questions...

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. See similar questions...

No. Visual Basic is a purely Microsoft standard and is not available for Unix. VB will probably never be widely used in the Unix community where there are thought to be far better object oriented languages available. There is however one product to convert VB code into java and and run active server pages: Halcyon Software <http://www.vbix.com/>. Python, for example, is an object oriented scripting language said to far exceed VB. See similar questions...

Why do I get the error 'Cannot use file <logfile> because it was originally formatted with a different sector size See similar questions...

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.. See similar questions...

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. See similar questions...

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. See similar questions...

The percentage of the project that will be converted is typically more than 99%. However, the percentage can vary greatly depending on the structure of your code. For instance, if Option Strict is On then it is significantly easier to convert your code because C# is more type strict. Please see Limitations and Workarounds (PDF file) for more details. You may also want to look at some sample converted projects. See similar questions...

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... See similar questions...

SQL is a declarative language that allows database programmers to write a SQL declaration and hand it to the database for execution. As such, SQL cannot be used to execute procedural code with conditional, iterative and sequential statements. To overcome this limitation, PL/SQL was created. PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL's language syntax, structure and data types are similar to that of Ada. See similar questions...

One can use the DBMS_OUTPUT package to write information to an output buffer. This buffer can be displayed on the screen from SQL*Plus if you issue the SET SERVEROUTPUT ON; command. For example: set serveroutput on begin dbms_output.put_line('Look Ma, I can print from PL/SQL!!!'); end; / DBMS_OUTPUT is useful for debugging PL/SQL programs. However, if you print too much, the output buffer will overflow. In that case, set the buffer size to a larger value, eg. See similar questions...

One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the "EXECUTE IMMEDIATE" statement (native SQL). Examples: begin EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)'; end; begin execute Immediate 'TRUNCATE TABLE emp'; end; DECLARE var VARCHAR2(100); BEGIN var := 'CREATE TABLE temp1(col1 NUMBER(2))'; EXECUTE IMMEDIATE var; END; Users running Oracle versions below Oracle 8i can look at the DBMS_SQL package (see FAQ about Dynamic SQL). See similar questions...