- oracle have for loop then it have many feature then Why Somebody are using Sql database?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Prakash KumarPosted Oct 31, 2016, 4:20 AM
SqlServer is much easier to use, this allows you to concentrate on what you want the database to do (solve some business problems) instead of wrestling the server all the time.
Because Oracle makes you configure so many settings, there are a lot of ways to get them wrong. This leads to endless discussions about partitioning, the type of index to use, etc etc. During those discussions, nobody is thinking about the business problems.
An analogy: I once had a olympus camera with a good lens and some simple settings. I made nice pictures with it so I upgraded to a DSLR with all kinds of knobs and dials. With that my pictures weren't half as good because I was concentrating on the camera instead of the subject.
That to me is the difference between Sql and Oracle. Sql is easier to work with and therefor gets more done. Ideas go from the whiteboard to working code so much faster. Only when you push for very large databases that Oracle might take the edge but I'm not even sure of that. Don;t thnk there's something that Oracle could handle that SQL couldn't.
Bikesh SrivastavaPosted Oct 21, 2016, 6:19 AM
Ananth GPosted Oct 21, 2016, 6:04 AM
Midhun TpPosted Oct 21, 2016, 5:56 AM