Difference between rowid and rownum in SQL?
- 1 Answers
- 1377 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer / yash
the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent
| Is This Answer Correct ? | 1 Yes | 0 No |
Can we write ddl in trigger?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How to make a column nullable?
How to join two tables in a single query in ms sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What are the restraints imposed on the table design by a merge replication?
Can another user execute your local temporary stored procedures?
What is the use of RDBMS?
what does the automatic recovery do? : Sql server administration
How many types of Cursor in SQL SERVER?
what is dbcc? : Sql server database administration
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
