How do you declare a variable in pl sql?



How do you declare a variable in pl sql?..

Answer / Sanatan Hansda

You can declare a variable in PL/SQL using the 'DECLARE' keyword followed by the variable name, data type, and optional initial value. For example: `DECLARE my_var NUMBER := 5;`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is normalization? : Sql dba

1 Answers  


What does pl sql stand for?

1 Answers  


how to load data files into tables with 'mysqlimport'? : Sql dba

1 Answers  


How do you update sql?

1 Answers  


What is pl sql architecture?

1 Answers  


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1 Answers  


Is like operator in sql case sensitive?

1 Answers  


What is a mutating table

5 Answers   TCS, Tech Mahindra,


Why do we use function in pl sql?

1 Answers  


Where is sql database stored?

1 Answers  


Which data type doesn't allow null data type?

6 Answers   TCS,


How to call the function and Procedure in trigger?

3 Answers   IBM,


Categories