This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of. Go to main content. Contents Title and Copyright Information Preface. Audience Documentation Accessibility. Plsql function result cache in 11g. PLSQL functions enable us to modularise and encapsulate our business logic, following generalised programming best practices. Oracle has become the worlds most flexible and robust database and along with great power comes great complexity. This complexity requires that. Please update and finalize this old, open question. Please 1 Award points. Moderator assistance to split points, comment here with details. The previous versions of SQL Server also provided outer join operator that available up to SQL Server 2. R2. By default it is disabled in SQL Server 2. R2. SQL Server 2. R2. SELECT cities. FROM cities, countries. WHERE cities. countryid countries. Error Msg 4. 14. Level 1. State 1, Line 3 The query uses non ANSI outer join operators or. To run this query without modification, please set the compatibility level for current database to 8. SET COMPATIBILITYLEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators LEFT OUTER JOIN, RIGHT OUTER JOIN. In the future versions of SQL Server, non ANSI join operators will not be supported even in backward compatibility modes. But you can enable outer join operator using SET COMPATIBILITYLEVEL option in the ALTER DATABASE statement. SQL Server 2. 00. R2. Enable outer join operator ALTERDATABASE test SET COMPATIBILITYLEVEL 8. SELECT cities. name, countries. FROM cities, countries. WHERE cities. countryid countries. Paris France London NULL. But there is no way to enable the outer join operator in SQL Server 2. SQL Server 2. 01. Try to enable outer join operator ALTERDATABASE test SET COMPATIBILITYLEVEL 8. Error Msg 1. 50. Level 1. State 1, Line 1 Valid values of the database compatibility level are 9. ALTERDATABASE test SET COMPATIBILITYLEVEL 9. SELECT cities. name, countries. FROM cities, countries. WHERE cities. countryid countries. Error Msg 1. 02, Level 1. State 1, Line 3 Incorrect syntax near. Oracle 1. 1g R2 SQL Language Reference. Microsoft SQL Server 2. Books Online. Dmitry Tolpeko, dmtolpekosqlines.