N/APosted on - 10/10/2012
How to convert PL SQL to vbscript? I don’t know if there is a way that any PL SQL coding can be converted to a vbscript. I just want to explore some details about programming languages and how they are related to other scripting process. I hope you can give me provide me the correct information.
How to convert plSQL to vbscript?
Here is a simple procedure that will help you:
Click the Windows "Start" button and then choose "All Programs." After that click "Oracle," then click the "Enterprise Manager" link to open the database programming software.
After that click "New Query" to open a query window for your PL SQL code, and then type the following code to convert integer values: select to_char(integer_column, char) from orders in order to alter "integer_column" to the column name that has integer values.
After that click "Run" in the Enterprise Manager toolbar. The code will execute and then return the data with the "text" data type.