Visual query designer functionality

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Mowelac
Posts: 3
Joined: Sun 17 Apr 2016 13:14

Visual query designer functionality

Post by Mowelac » Sun 17 Apr 2016 13:19

Is it possible to create such a query using visual query designer?

Code: Select all

select FirstLetter as DisplayVal, FirstLetter as ResultVal
from  (select distinct substr(EMPLOYEES.LAST_NAME, 1, 1) as FirstLetter
       from EMPLOYEES)

Mowelac
Posts: 3
Joined: Sun 17 Apr 2016 13:14

Re: Visual query designer functionality

Post by Mowelac » Sun 17 Apr 2016 19:29

It can simply be done with subquery, Query → Create Subquery

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Visual query designer functionality

Post by alexa » Mon 18 Apr 2016 09:11

This can be performed with the Query Builder feature of dbForge Studio for Oracle https://www.devart.com/dbforge/oracle/s ... nload.html

Please also see the following material:
https://www.devart.com/dbforge/oracle/s ... tml#header
https://www.devart.com/dbforge/oracle/s ... uilder.htm
https://www.devart.com/dbforge/oracle/s ... -more.html

You can download a fully featured 30-day Trial version and try this feature http://www.devart.com/dbforge/oracle/st ... nload.html

The feature list for the editions of dbForge Studio for Oracle can be found at https://www.devart.com/dbforge/oracle/s ... tions.html

Mowelac
Posts: 3
Joined: Sun 17 Apr 2016 13:14

Re: Visual query designer functionality

Post by Mowelac » Mon 18 Apr 2016 18:44

Thank you, alexa, as I mentioned, I have managed to make required query using subquery. Following SQL, constructed in visual builder, does what I want:

Code: Select all

SELECT DISTINCT SubQuery.FirstLetter AS DisplayVal,
                SubQuery.FirstLetter AS ReturnVal
  FROM EMPLOYEES,
       (SELECT SUBSTR(EMPLOYEES.LAST_NAME, 1, 1) AS FirstLetter
           FROM EMPLOYEES) SubQuery
  ORDER BY DisplayVal

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Visual query designer functionality

Post by alexa » Tue 19 Apr 2016 07:38

Thank you for updating us on this issue. Please let us know if any question arise.

Post Reply