Hello Experts,
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.
Thank you.
How to convert plSQL to vbscript?
Hello Christine,
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.
Regards,
Nicke