Differences Between Oracle And PostgreSQL Open Source Database [2015]

In this Video you will come to know the differences between Oracle And PostgreSQL Databases. In coming days I will do more videos based on this topic. This video help the developers to Migrate from Paid database to opensource database.
60% Oracle queries working properly in PostgreSQL, So its easy to migrate. PostgreSQL contains ACID property. Compare to Oracle, PostgreSQL retrieve data quickly (Refer my Blog: clearosapps.blogspot.in/2015/1... ).
The queries which i used in this video are available in my blog - clearosapps.blogspot.in/
If you have any difficulties, any queries drop comments, like the video, Share it and subscribe the Channel for further updates.
Re-upload Video : • Differences Between Or...
Background Music used: Gold Coast by Jens Kiilstofte machinimasound.com/music/gold...
Licensed under Creative Commons Attribution 4.0 International (creativecommons.org/licenses/b...)

[@kodandram373]

In the Video do you really required a background music. Which is really irritating.

[@8bitzs]

It is depends on people, some loves the background music. You don't like music or this music only?

[@kodandram373]

When class is going on music is disturbing. The purpose of your video is not reached to the people. Your topic is very good. But because of the music I cannot concentrate. If you can please remove music from tutorials. If I like to listen music, i can choose music from you tube.

[@8bitzs]

I appreciate your suggestion and i will apply the same in my new video tutorials. Thank you.

[@vajravelumani1827]

This video doesn't discuss any architectural of functional differences , just says how oracle queries doesnt work on postgresql

[@andishez5359]

Thank you so much, Fast , Simple and useful , really good for quick answer to our doubts about their diff

[@8bitzs]

You are welcome

[@AmmuAlpha]

Please post this same vidoe without music .. its like musci is only dominating we r not able to focus or hear well abt what is explained

[@8bitzs]

As per your request video is re-uploaded. Please watch, thank you for the suggestion. kzbin.info/www/bejne/hofQgXqQasanrbc

[@JohnWheaton2PF]

Absolutely incomprehensible over the background music. I agree with the request to re-post this without the music.

[@8bitzs]

As per your request video is re-uploaded. Please watch, thank you for the suggestion. kzbin.info/www/bejne/hofQgXqQasanrbc

[@KMDmello]

Can you explain more about PostgreSQL as I can choose my database. Whether it work same as Microsoft SQL?

[@8bitzs]

Yes it is an open source database. It is working same as Oracle and MS SQL server. But the commands name and methods are different. If we compare Oracle with SQL server then also commands are different. It has ACID property. Functioning same as MS SQL server. Example for command diff: If we want a single row out of 100 rows then Oracle - select * from emp where rownum=1 SQL Server - select top 1 * from emp PostgreSQL - select * from emp limit 1

[@8bitzs]

I have compared Oracle and PostgreSQl database data fetching time in same server and PostgreSQL gives the result quickly. Here is my blog regarding this clearosapps.blogspot.ae/2015/10/oracle-vs-postgresql-which-is-faster.html

[@risri89]

What's the client you are using for postgre?

[@8bitzs]

Pgadmin

[@brlrao468]

single quote is not equivalent to null in oracle.. you have to specify the keyword NULL in oracle.

[@8bitzs]

yes but for null if you write single quote then also it will give the output

[@anderssjoqvist7816]

There is no "Postgre". Postgres is post-Ingres, and the name thus ended with an S before the project transitioned to supporting SQL. You may call it "postgres" or "postgres-Q-L".

[@8bitzs]

Noted, you can watch the latest uploaded video kzbin.info/www/bejne/hofQgXqQasanrbc

[@larsdohn553]

Why the music ?

[@8bitzs]

As per your request video is re-uploaded without music. Please watch, thank you for the suggestion. kzbin.info/www/bejne/hofQgXqQasanrbc

[@Winningmindsetai]

Bhai..your number...u gave comment

[@8bitzs]

Comment in?

[@is7964]

loud music

[@8bitzs]

Video is re-uploaded without music. Please watch, thank you for the suggestion. kzbin.info/www/bejne/hofQgXqQasanrbc