New to DBForge for Oracle - question about prompts

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
heatherR
Posts: 1
Joined: Mon 15 Jun 2020 14:58

New to DBForge for Oracle - question about prompts

Post by heatherR » Mon 15 Jun 2020 15:04

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!


emmasophia
Posts: 1
Joined: Thu 30 Dec 2021 11:10

Re: New to DBForge for Oracle - question about prompts

Post by emmasophia » Thu 30 Dec 2021 11:12

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?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: New to DBForge for Oracle - question about prompts

Post by dzhanhira » Fri 31 Dec 2021 09:00

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

floydprice1
Posts: 1
Joined: Thu 18 Aug 2022 02:44

Re: New to DBForge for Oracle - question about prompts

Post by floydprice1 » Thu 18 Aug 2022 02:45

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

sweetcandysp
Posts: 1
Joined: Sat 27 Aug 2022 08:05

Re: New to DBForge for Oracle - question about prompts

Post by sweetcandysp » Sat 27 Aug 2022 08:06

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

Amrikaa
Posts: 1
Joined: Fri 02 Sep 2022 11:42

Re: New to DBForge for Oracle - question about prompts

Post by Amrikaa » Fri 02 Sep 2022 11:43

This would create a pop up before running.

Post Reply