Oracle sql developer declare variable3/20/2023 Once a particular value has been assigned, it will be stored in the allocated memory space for that variable.Declaration of variables is a process of assigning the name to the placeholder and associate the same with a valid datatype.Variables in PL/SQL are basic identifiers assigned to a storage area that a program can manipulate.To avoid confusion and to increase the readability of such program, we need to follow certain naming conventions. In a complex program, sometimes we may have to include many identifiers.Identifiers in PL/SQL are nothing but names given to a PL/SQL object.When the above code is executed, you will get the following output. Code line 6: Printing the stored value of variable ‘lv_name’.Code line 5: Value for variable ‘lv_name’ has been assigned from the variable ‘lv_name_2’.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |