Oracle PL-SQL Question:
Download Questions PDF

Can we declare a column having number data type and its scale is larger than pricesion
ex: column_name NUMBER(10,100),
column_name NUMBAER(10,-84)

Answer:

Yes,we can declare a column with above condition.table created successfully.

yes, 100 is the total size and 10 is included in 100

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What are the Restrictions on Cursor Variables?What will happen after commit statement?