Visual query designer functionality

Visual query designer functionality

Postby 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

Postby Mowelac » Sun 17 Apr 2016 19:29

It can simply be done with subquery, Query → Create Subquery
Mowelac
 
Posts: 3
Joined: Sun 17 Apr 2016 13:14

Re: Visual query designer functionality

Postby 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/studio/download.html

Please also see the following material:
https://www.devart.com/dbforge/oracle/studio/oracle-query-builder.html#header
https://www.devart.com/dbforge/oracle/studio/docs/index.html?building_queries_with_query_builder.htm
https://www.devart.com/dbforge/oracle/studio/learn-more.html

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

The feature list for the editions of dbForge Studio for Oracle can be found at https://www.devart.com/dbforge/oracle/studio/editions.html
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17

Re: Visual query designer functionality

Postby 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
Mowelac
 
Posts: 3
Joined: Sun 17 Apr 2016 13:14

Re: Visual query designer functionality

Postby alexa » Tue 19 Apr 2016 07:38

Thank you for updating us on this issue. Please let us know if any question arise.
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle