How to convert plSQL to vbscript?

Asked By 50 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #183531

How to convert plSQL to vbscript?

qa-featured

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

Related Questions