adspace


What is the maximum number of rows in sql table?

Answer Posted / Deepak Yadav

There isn't a fixed limit for the number of rows that can be stored in a SQL table, as it depends on various factors such as storage capacity, hardware, and database management system. However, Oracle Database has a limit of 17 billion rows per table by default (in a non-indexed table), but this can be increased.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to escape special characters in sql statements? : Sql dba

1125


Does group by remove duplicates?

1122


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


Can we rollback truncate?

1086


what is collation? : Sql dba

1242


what are the advantages of sql ? : Sql dba

1154


If a cursor is open, how can we find in a pl/sql block?

1252


Is inner join faster than left join?

1289


what are aggregate and scalar functions? : Sql dba

1143


how to use regular expression in pattern match conditions? : Sql dba

1125


Can delete statement be rollbacked?

1065


What is the current version of postgresql?

1189


Is primary key always clustered index?

1101


What is the current version of sql?

1106


define sql insert statement ? : Sql dba

1110