What is the difference between numeric and autonumber?



What is the difference between numeric and autonumber?..

Answer / Firoz Dost

In SQL, NUMERIC is a data type used for exact numerical values with decimal points, while AUTOINCREMENT (also known as IDENTITY in some databases) is a property that automatically assigns unique numerical values to new records.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is synonyms?

1 Answers  


What is pl/sql table? Why is it used?

1 Answers  


What are sql data types?

1 Answers  


Why truncate is faster than delete?

1 Answers  


how many no of table can be join in a sql query.

4 Answers  


What is the maximum number of columns in sql table?

1 Answers  


What are the most important ddl statements in sql?

1 Answers  


what is the order of pre-defined exceptions.

6 Answers   TCS,


Can ddl statements be used in pl/sql?

1 Answers  


Is sql easier than java?

1 Answers  


What are the operators used in select statements?

1 Answers  


How do I find duplicates in two columns?

1 Answers  


Categories