Oracle IDE to visually create views?

Oracle IDE to visually = wizard开发者_StackOverflow社区 (not writing sql) create views? any names? (eg like toad)

SQL Server Management Studio = can create views visually for sql server what is same for oracle

Have you tried SQL Developer?

Once installed and connected - try the following.

1) Right click on Views icon

2) New View

3) Click Advanced check box

4) Interface appears which allows you select tables, where clauses etc.

EDIT: Just thought I would point out that the above allows the use of a "wizard" type interface to create a view. Not sure if that meets your requirement of "Visual"

Want a purley visual experience? Try DeZign for Databases by Datanamic. I haven't purchased the tool, but after an initial evaluation I'm wanting it. It lets you drag and drop items onto a visual designer and then generates the DDL for you.

A little late, by here's an online designer - WWW SQL Designer

Its mainly for MySQL but nevertheless pretty useful