Difference between rowid and rownum in SQL?
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 |
What are the advantages of user defined function?
How to get number of days in a given year?
What is an index. What are the types?
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"
How will you find out if there are expensive SQL statements running or not?
what is IDE,DMV in sql server?
what is diffence between replicaion and logshipping?
How to Generate a Series of Random Integers With T-SQL?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How do you find the number of rows in a table?
What are the options which must be set to allow the usage of optimistic models?
How to connect php with different port numbers?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)