Oracle IDE to visually = wizard (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
+1
A:
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"
carpenteri
2009-10-07 08:09:40
+1
A:
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.
Kevin Babcock
2009-10-07 14:18:53
A:
A little late, by here's an online designer - WWW SQL Designer
Its mainly for MySQL but nevertheless pretty useful
Sathya
2009-10-07 17:53:41