Analyzing Object Storage and Segments 1. Assessing Table Size and Row Counts To evaluate storage consumption across all schemas, join the data dictionary views regarding tables and segments. The following query calculates size in gigabytes and retrieves row estimates. -- Segment size analysis across...
Data Definition Language (DDL) DDL encompasses commands used to define and modify database schema structures. These operations affect the organization and properties of database objects rather than the data itself. Key commands include: CREATE: Establishes new database objects ALTER: Modifies existi...
Basic SQL Queries Simple Queries -- Query all data from the employee table: SELECT * FROM employee; -- * represents all columns -- Display specific columns: SELECT employee_id, name, salary FROM employee; -- Filter rows using WHERE clause: SELECT * FROM employee WHERE salary > 2000; -- Combine co...
This article demonstrates practical methods for querying data across multiple tables using join operations and subqueries. The examples utilize a sample database named XSCJ containing student, sc (student-course), and course tables. 1. Retrieve Student IDs, Names, Course Numbers, and Grades This que...
UPDATE Function Description Updates data in a table. The UPDATE statement modifies specified columns in all rows that meet the declared condition, with the condition set via the WHERE clause. Columns listed in the SET clause are updated, while unlisted columns retain their original values. Notes Thi...
In SQL, the NOT NULL constraint ensures that a column does not accept NULL values. This constraint is typically used when creating or modifying tables to ensure data integrity and accuracy. Here are some common uses of NOT NULL: Specifying NOT NULL Constraint When Creatign a Table: When creating a n...
PostgreSQL is known for its strict type system. Unlike some database that perform aggressive implicit type coercion, PostgreSQL often requires explicit instructions when transforming data from one format to another. Failing to handle these transitions correctly results in runtime exceptions that can...
Challenge Overview Source: BUUCTF Platform Objective: Retrieve the flag value. Approach The challenge presents a web page with minimal visible content. The URL contains a query parameter ?id=1, indicating this is a standard SQL injection vulnerability. Determining Injection Type First, test whether...
1. INSERT Statement (Creating Data) The INSERT statement is used to add new records to a table. Basic Syntax CREATE TABLE employees ( id INT, name VARCHAR(50) ); INSERT INTO employees VALUES (1, 'John'); INSERT INTO employees VALUES (2, 'Alice'); In SQL, both single quotes and double quotes can be u...
Structured Query Language (SQL) is a standardized programming language designed for managing relational databases. It enables users to define, query, manipulate, and control data within database management systems. The term SQL can be pronounced either letter by letter (/ˌɛsˌkjuːˈɛl/) or as a single...