JOIN IN ORACLE




Comments

Post a Comment

Popular posts from this blog

MongoDB Index & Index Types

Image
MongoDB Index & Index Types  Introduction MongoDB, a powerful NoSQL database, is designed for scalability, high availability, and performance from single server deployments to large complex multi-site architectures. One of the essential features of MongoDB that helps in achieving these goals is the Index. What is an Index? An index in MongoDB is a special data structure that holds the data of few fields of documents on which the index is created. Indexes improve the performance of search operations in the database as they provide a more efficient path to the data. Just as an index in a book helps you locate content quickly, a MongoDB index allows the database to find and retrieve specific documents much faster than it would without an index. How to create an index:- Now that we have an understanding of what indexes are and when to use them, we can get into the method of creating one. Once you have identified a field that could benefit from indexing, you use the createIndex() me...
Read more

Backup and Recovery in MySQL database

1. Create backup for single database.   mysqldump -u root -p pankaj > /home/backup/ramjee.sql; 2. create backup for set utf8 character in single database.   mysqldump -u root -p --default_character_set utf8 pankaj >               /home/backup/ganga.sql 3.create backup for multiple database.    mysqldump -u root -p --databases pankaj sys mysql >   /home/backup/multidatabase.sql 4.create backup for all database. mysqldump -u root -p --all-databases > /home/backup/fulldatabase.sql 5.create backup for single table. mysqldump -u root -p pankaj emp > /home/backup/singletable.sql 6. how to create backup structure only.  mysqldump -u root -p --no-data pankaj emp > structureonly.sql 7.how to backup data only. mysqldump -u root -p --no-create-db --no-create-info pankaj emp > /home/backup/dataonly.sql
Read more