Devart Forums

Hello,

I've recently switched from TOAD for Oracle to DBForge and we have some canned queries with prompts to allow for filters but they won't run in DBForge.

In toad you would use && to create a prompt for input for a filter, for example:

BETWEEN TO_DATE ( '&&StartDate',
'dd-mon-yyyy hh:mi;ss PM')
AND TO_DATE (
'&&EndDate',
'dd-mon-yyyy hh:mi:ss PM')

This would create a pop up before running.

Is there an equivalent in DBForge?
Thanks!

You may be interested in the following feature https://docs.devart.com/studio-for-oracle/writing-and-executing-sql-statements/using-parameters.html

Hello Everyone.
I hope you are fine.
I want to know about the SQL.
Do we use a SQL codes in a website or not?

Hi there,
Thanks we are doing good, hope you too.
Could please clarify your question? What do you want to perform?

You will need to switch from TOAD for Oracle to Oracle to fix this problem. So, you can use Oracle's SQL database to run queries, and the database management tool will work as it shouldflagle

Thanks, it's work!
I didn't recognize to this option
lewdle

This would create a pop up before running.