9/21/2023 0 Comments Mysql interview questions![]() ![]() CHAR (fixed-length character value range between 1 and 32,767 characters).Scalar Data Types: A scalar data type is an atomic data type that does not have any internal components. ![]() There are 4 types of predefined data types explained as follows: Q #3) What are the data types available in PL/SQL?Īnswer: Data types define the ways to identify the type of data and their associated operations. Improved transaction performance with integration to Oracle data dictionary.With PL/SQL users can write their own customized error handling routines.It is known for the portability of code as code can be executed on any operating system provided that Oracle is loaded on it.PL/SQL allows access and sharing of the same subprograms by multiple applications.Q #2) Enlist the characteristics of PL/SQL?Ĭharacteristics of PL/SQL are as follows: PL/SQL supports customized error handling. No error handling procedures are there in SQL. PL/SQL statements send the entire block of statements to the database server at the same time, thus network traffic is reduced considerably. PL/SQL supports procedural capabilities as well as high language features such as conditional statements, looping statements, etc.Īll SQL statements are executed by the database server one at a time, thus it is a time-consuming process. No procedural capabilities like condition testing, looping is offered by SQL. PL/SQL is a procedural extension of Oracle - SQL. SQL is a natural language which is very useful for interactive processing. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |