![]() ![]() Like we said above, embedded SQL is the one which combines the high level language with the DB language like SQL. ![]() Hence when user submits a request or enters values in the form, he gets the result what he is requested. These SQLs provide the utility to use SQLs inside the application language like C, C++, Java etc, and make these applications to communicate with DB. This gap between application programs and SQL is bridged by the use of embedded SQL and dynamic SQLs. Hence both are dependent on each other too. But in order to make application programs to work, DB is compulsory and for any DB to be used by the user application/UI is a must. Hence both application language and DB language are completely different from each other. Similarly DB languages like SQL, SQL servers etc are meant for only DB activities. They are not meant for any DB activities. These languages are used to get UIs, forms etc. But how application communicates with DB? Applications are developed using some general purpose languages like C, C++, JAVA, etc. Hence user need not have any knowledge about the DB. The underlying application program will manipulate his request. In order to make easy for the normal user, applications, UI or forms are created where user can enter his values or requirement. Actual use of DB is for normal user for whom DB is a black box. But in real time, these developer or programmers will not be using the database. But all these transactions can be performed by a good database developer or a SQL programmer who has good knowledge about database as well as SQL. They are used only to query tables / views, manipulate the data values using insert/update/ delete, or set of transactions can be executed one after the other to modify set of tables/view. The condition in WHENEVER clause can be IntroductionÄatabase languages are meant for dealing with databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |