Sunday, June 30, 2013

How to create database view with Oracle SQL Developer Data Modeler


In this post will show how to create database view, the creation of database view in Oracle SQL Developer Data Modeler is different with the creation of database view, and it is missing from the previous posts.

Steps:
1. Make sure the SQL Developer Data Modeler is showing the relational view.
a) click on the New View icon
b) move the cursor to the workspace (top-right pane) to bring up the View Properties dialog.
Click New View icon


2. Enter new view name

3. Click Query button to bring up the Query Builder dialog
Enter View's properties

4. Add Object inside the Query Builder
a) d-click on any object inside the top-right pane.

5. Choose columns from all the objects added.
Query Builder

6. If required UNION
a) R-click "Q" button
b) click New union sub-query
Create New union sub-query

7. Repeat step 4-5 to add object and columns for the New union query

8. verify the generated SQL for the view

9. modify if required, eg. change to UNION ALL

10. test the SQL if required
Generated SQL for the view from the above settings

11. Click OK > OK

Output:

Output - View in green colour


Done!!

23 comments:

  1. Thank you. It was very useful.

    ReplyDelete
  2. i read a lot of stuff and i found that the way of writing to clearifing that exactly want to say was very good so i am impressed and ilike to come again in future.. Data Blending in Tableau

    ReplyDelete
  3. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. Tableau Data Blending

    ReplyDelete
  4. Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!.

    data science training in raipur

    ReplyDelete
  5. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    ai training in varanasi

    ReplyDelete
  6. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
    ai training in mysore

    ReplyDelete
  7. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I am looking forward to reading new articles. Keep up the good work! I would like to add a little comment data analytics course in hyderabad

    ReplyDelete
  8. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    data analytics course in hyderabad
    business analytics course
    data science course in hyderabad

    ReplyDelete
  9. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    ai course in surat

    ReplyDelete
  10. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Avenue South Residence

    ReplyDelete
  11. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. The Avenir

    ReplyDelete
  12. I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles.

    data science course in indore

    ReplyDelete
  13. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. midtown modern condo

    ReplyDelete
  14. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Clavon Condo

    ReplyDelete
  15. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. myra condo

    ReplyDelete
  16. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. One Pearl Bank

    ReplyDelete
  17. i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. Hyll On Holland

    ReplyDelete
  18. Call Clavon Showflat Hotline @ +65 6100 9266 / 90261759 for Showflat Appointment, Clavon Showroom Location, Price, Floor plans, E-brochure, VVIP Discount & Site Plans. Clavon Showflat

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. it was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity..
    data science course in guwahati

    ReplyDelete
  21. It’s very informative and you are obviously very knowledgeable in this area. You have opened my eyes to varying views on this topic with interesting and solid content. apartments for sale near me

    ReplyDelete
  22. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! areas to invest in property uk

    ReplyDelete

LinkWithin

Related Posts Plugin for WordPress, Blogger...