what is dialect?

[manas ranjan mandal]

i want to know that what is dialect in database?

thanks in advance

[Jeanne Boyarsky]

Dialect is an English word that means variant of a language. For example, there are multiple dialects of English. For example, British English and American English.

In the context of databases, people talk about dialects of SQL. SQL is the main language just as English is. Then there are dialects with database specific syntax. For example, Oracle has the rownum keyword.

[Vamsi Mohan]

Dialect is a DB supporting type in Hibernate. Based on Dialect, your application connects to your mentioned database. It is mandatory for DB connection.

[Jeanne Boyarsky]

Vamsi,
Please check your PMs.