1.

Define Native Sql?

Answer»

Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a QUERY subject that references more than one data source in the project.

ADVANTAGES:

  • PERFORMANCE is optimized across all related query SUBJECTS.
  • You can use SQL that is specific to your database.

Disadvantages:

  • You cannot use SQL that the data source does not support for sub queries.
  • The query subject may not work on different database type.

Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a query subject that references more than one data source in the project.

Advantages:

Disadvantages:


Discussion

No Comment Found

Related InterviewSolutions