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)

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home Oracle PL-SQL

⟩ 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)

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

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

Is this answer helpful?
0 Yes | 0 No

211 views

More Questions for you:

What are things which play major role in designing the backup strategy?

What is RAID? What is RAID0? What is RAID1? What is RAID 10?

How to identify the block corruption in RMAN database? How do you fix it?

Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it?

Explain the steps involved in SCN based recovery from the full database from hot backup?

What is the difference between physical and logical backups?

Tell me is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?

Explain the steps for changing the DBID in a cloned environment?

How RMAN improves backup time?

What is the difference between obsolete RMAN backups and expired RMAN backups?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home Oracle PL-SQL

⟩ 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)

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home Oracle PL-SQL

⟩ 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)

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: