Question
How to declare a local variable?
Answers
A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements:

PROCEDURE proc_var_1 AS
domain VARCHAR2(80);
price REAL;
is_for_sale CHAR;
BEGIN
-- Executable statements
END;   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q Which of the following IS functions may be performed by the same individual, without compromising on control or violating segregation of duties? A. Job control analyst and applications programmer B. Mainframe operator and system programmer C. Change/problem and quality control administrator D. Applications and system programmer
  • Q What is Ronald Reagan's middle name
  • Q Which Plan projected the Constituent Assembly' to frame a Constitution of India?
  • Q What command is used to get back the privileges offered by the GRANT
  • Q Production of which is a function of the liver?
  • Q How to access the project name from a groovy script test step?
  • Q Name the first US president to serve ice cream at a state dinner
  • Q Spell the city name: Pnom Penh; Phnom Penh; Phnom Penn; or Pnhom Pehn?
  • Q True or False, brain fingerprinting has been used to obtain guilty plea from criminals. (A)True (B)False
  • Q An EPC is still compulsory even though HIP's were abolished? (A)True (B)False
  • Q Who was the last Roman Catholic King of England