Posts Tagged ‘Oracle’

Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

nosql vs sql databases differences

Following are major differences between NoSql and Sql databases NoSQL Database SQL Databases Open Source databases Mixed(Open source and closed source) Different types including key-value stores, document databases, wide-column stores, and graph databases One type (SQL database) with minor variations Examples: MongoDB, HBase, Cassandra, Neo4j Oracle, PostgreSQL, MySQL, Microsoft SQL Server, Sybase

Powered by k2schools