Primavera P 6 SQL database and P6 version 7 oracle database

Praveen;

For me the major difference is that SQL allows you to have several databases, Oracle only one.

For a consultant with several clients this could be important.  It helps isolate client calendars and activity codes to keep things as simple as possible.  SQL gets limited support from Oracle, but that does not seem to be a major problem right now.  If your data is subject to discovery, multiple databases may ensure that only the required data is surrendered - not very likely, but a consideration.

No experience with Oracle databases, but both generate .xer files that can be read by any other P6 user.