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!
New to DBForge for Oracle - question about prompts
Re: New to DBForge for Oracle - question about prompts
You may be interested in the following feature https://docs.devart.com/studio-for-oracle/writing-and-executing-sql-statements/using-parameters.html
-
- Posts: 1
- Joined: Thu 30 Dec 2021 11:10
Re: New to DBForge for Oracle - question about prompts
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?
I hope you are fine.
I want to know about the SQL.
Do we use a SQL codes in a website or not?
Re: New to DBForge for Oracle - question about prompts
Hi there,
Thanks we are doing good, hope you too.
Could please clarify your question? What do you want to perform?
Thanks we are doing good, hope you too.
Could please clarify your question? What do you want to perform?
-
- Posts: 1
- Joined: Thu 18 Aug 2022 02:44
Re: New to DBForge for Oracle - question about prompts
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
-
- Posts: 1
- Joined: Sat 27 Aug 2022 08:05
Re: New to DBForge for Oracle - question about prompts
This would create a pop up before running.