MongoDB: sort(), skip(), and limit()
admin
These three methods are commonly used with find() to sort records, skip records, and restrict the number of records returned. Assume we have a students collection: Example data: 1. sort()…
Mongodb remove()
In MongoDB, remove() is used to delete documents from a collection. Note: remove() is an older MongoDB method. In modern MongoDB, use deleteOne() or deleteMany(). 1. Remove One Document Suppose:…
Mongodb Update()
Here are different MongoDB update() examples in English, explained simply. Note: In modern MongoDB, use updateOne() and updateMany() instead of the older update() method. 1. Update One Field Suppose we…
MongoDB Operator
Below is a complete Employee (emp) practical example with data and common find() queries, including AND, OR, NOT, and NOR. 1. Create Database and Employee Collection Insert employee records: 2.…
Advanced Custom Fields (ACF) for WordPress, here’s a simple example.
Example: Add an employee’s details Suppose you have a WordPress Employee post type and want to add: With ACF, you can create these as custom fields instead of putting everything…
Mongodb Syllabus
Msc_IT&CA_-1-2-2022 (1)-12-15Download
trigger example
CREATE OR REPLACE TRIGGER trg_emp_insertAFTER INSERT ON empFOR EACH ROWBEGIN— Insert into audit tableINSERT INTO emp (emp_id, emp_name,salary)VALUES (:NEW.emp_name,:NEW.salary,:NEW.emp_id); — Display messageDBMS_OUTPUT.PUT_LINE(‘Employee inserted successfully.’); END; insert into emp(emp_name,salary,emp_id)values(‘rohan’,3000,3);select * from…
What is Theme?
1. What is a Theme? A WordPress Theme is a collection of files (templates, stylesheets, images, and scripts) that controls the appearance, layout, colours, fonts, and overall design of a…
Media Files in WordPress
A Media File in WordPress is any file that you upload to your website, such as images, videos, audio files, or documents. All uploaded files are stored in the Media…
VARRAYs (Variable-Size Arrays) in Oracle PL/SQL
VARRAYs (Variable-Size Arrays) in Oracle PL/SQL What is a VARRAY? A VARRAY (Variable-Size Array) is an Oracle collection type that stores a fixed maximum number of elements of the same…