X

Shay Shmeltzer's Oracle Development Tools Tips

Managing Oracle Database Code with SQL Developer, Git, and Developer Cloud Service

Shay Shmeltzer
Director of Product Management - Oracle

Are you coding SQL and PL/SQL code? Need to manage versions & branches? Want to track your to-do tasks? Need to conduct code reviews and peer programming? 

Developer Cloud Service can help you!

And now it comes free with your Oracle Database Cloud Service trial or license - check your service dashboard to see if you got one.  Note that even if your database is not in the cloud, but rather on-premises, you can use the same process shown in the video below.

In the demo you'll learn how to:

  • Provision a new cloud project for your team
  • Check SQL scripts into the Git Repository in DevCS
  • Track tasks and to-do items
  • Branch your SQL script code
  • Conduct code review with members of your team
  • Merge branches of code

Check it out:

I blogged about this topic in the past using JDeveloper, but figured out that most of the Oracle database developers actually use SQL Developer - so I thought it would be good to give them a quick 10 minute demo of what they can do by combining the power of SQL Developer and Developer Cloud Service. (The video can also be useful to just get a basic understanding of how SQLDeveloper works with any Git repo).  

More about Developer Cloud Service here.

Stay tune for more blog entries on features for Database developers in Oracle Developer Cloud Service - coming soon!

Join the discussion

Comments ( 3 )
  • Daniel Eusebio Thursday, August 16, 2018
    Can you show a change in a table, for example add a column, alter a procedure that uses data from the new column, commit the changes, and apply the changes?
    Thank you.
  • Jason Zwolak Wednesday, March 17, 2021
    I second Daniel Eusebio's comment. The problem I haven't found a solution to with Oracle is that of changes to tables. Ruby on Rails solves this with database migrations in a somewhat nice way (though there are problems there, but it's good enough for most cases). I don't see anything like this in the Oracle ecosystem. I wonder if there is a best practice for how to handle changes to tables and version control this and synchronize these changes from development to production.

    Mostly, I try to use dated scripts and the `alter table` SQL command, which is a simplified imitation of Rails migrations. Is this what people do?
  • Shay Shmeltzer Thursday, March 18, 2021
    There are frameworks that you can use to manage table structure changes better - for example Liquibase that is well integrated into Oracle now with SQLcl support.
    See this demo for example - https://blogs.oracle.com/shay/vbsliquibase
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.