Here are the steps to Add, Remove, Edit, and Publish Pages, Posts, Tags, and Categories in WordPress.
1. Pages in WordPress Add a New Page Edit a Page Remove (Delete) a Page 2. Posts in WordPress Add a New Post Edit a Post Delete a Post 3.…
My Blog
1. Pages in WordPress Add a New Page Edit a Page Remove (Delete) a Page 2. Posts in WordPress Add a New Post Edit a Post Delete a Post 3.…
A Cursor is a pointer to the result set of a SQL query. It allows PL/SQL to retrieve and process one row at a time from the query result. Cursors…
A PL/SQL Block is the basic unit of a PL/SQL program in Oracle. It is a group of SQL and PL/SQL statements that are executed together as a single unit.…
select * from dept_1; create view v1 as select id,name from dept_1; create table dept_1(id int,name varchar2(50));insert into dept_1 values(1,’mitak’);insert into dept_1 values(12,’sss’);insert into dept_1 values(10,’mitak’);insert into dept_1 values(3,’mitak’); select…
Depending on the context, it could mean several things: What is a Lock in Oracle? A lock in Oracle is a mechanism used to control concurrent access to database data.…
In Oracle Database, a cluster is a schema object that stores rows from one or more tables that have a common column in the same data blocks. This improves the…
In Oracle, you create an index using the CREATE INDEX statement. Syntax Example 1: Create a Simple Index Suppose you have an employees table: This creates an index on the…
In Oracle, a synonym is an alias (alternate name) for a database object such as a table, view, sequence, procedure, function, package, or materialized view. Synonyms simplify object access and…
In Oracle, a sequence is a database object that generates unique numeric values, often used to create primary key values automatically. Syntax to create a sequence Example Create a sequence:…
In Oracle, a View is a virtual table created from the result of a SQL query. It does not store data itself; instead, it stores the SQL statement. Whenever you…