adspace


How to declare a local variable?

Answer Posted / Kajal

In Oracle PL/SQL, you can declare a local variable using the `VARIABLE` keyword followed by the name and data type of the variable. Here's an example:nn```sqlnDECLAREn my_variable VARCHAR2(50);nBEGINn ...nEND;n``

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use values from other tables in update statements using oracle?

1158


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956


How to write a left outer join with the where clause in oracle?

1156


How to put more than 1000 values into an oracle in clause?

1115


Design database draw er diagram for a certain scenario ?

4656


How to select all columns of all rows from a table in oracle?

1132


How to start an oracle instance?

1103


What is oracle latest version?

1174