Start a new topic

Using variables at dbvis 9.1.6

anonymous

started a topic over 10 years ago

[This topic is migrated from our old forums. The original author name has been removed]

I want to know if it is possible to use variables at dbvis.

Exemple:

DECLARE CODCLIENT NUMBER (10);
SET CODCLIENT = 150

SELECT NAME
FROM CLIENTS
WHERE CODCLIENT = :CODCLIENT

PS: I'M USING ORACLE

1 Comment

Hans Bergsten

said over 10 years ago

[This reply is migrated from our old forums.]

Re: Using variables at dbvis 9.1.6

Hi Saulo,

You can use DbVisualizer variables for any database, please see the Users Guide:

http://confluence.dbvis.com/display/UG91/Using+DbVisualizer+Variables

For some databases, you can also use Parameter Markers (? or :name), but not all JDBC drivers provide the info needed to support that in DbVisualizer. The Oracle JDBC driver is one that does not give enough info.

Best Regards,
Hans

How can we help you today?

Using variables at dbvis 9.1.6

anonymous

Hans Bergsten