what do you understand by the following pl pgsql declaration cphone customer..., PostgreSQL, Databases

Test
- Model Test
Index

Question:What do you understand by the following PL/pgSQL declaration?
c_phone customer.contact_no%TYPE;

A This is declaring a new variable c_phone with undefined type 
B This is declaring a new variable c_phone with same type as contact_no column 
C This is declaring a new variable c_phone with variable data type 
D None of these above is correct

/85

+ AnswerB

+ Report

Descriptive on PostgreSQL Ebook

Total Preview: 620

Question:What do you understand by the following PL/pgSQL declaration? c_phone customer.contact_no%TYPE;

A This is declaring a new variable c_phone with undefined type

B This is declaring a new variable c_phone with same type as contact_no column

C This is declaring a new variable c_phone with variable data type

D None of these above is correct

B