How to convert plSQL to vbscript?

Asked By Christine Yong 50 points N/A Posted on - 10/10/2012

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.

• Status: Open
• Question Views: 1211
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Nicke Baker 0 points N/A #183531

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

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 10/11/2012
• Question Category: Visual basic