Search guides, SQL, error codes, and procedures — or browse by topic below.
388 guides · 8 topics
API to Update FND_LOOKUP DECLARE l_lookup_type VARCHAR2 (250); l_lookup_code VARCHAR2 (250);...
Oracle SQL Performance & TuningOracle provides features and tools to analyze and tune query performance.Execution PlansI...
Basic SELECTSELECT name, salary FROM employees;All ColumnsSELECT * FROM employees;
SELECT DISTINCT A.APPLICATION_ID , A.application_short_name , b.application_name , c.RESPO...
DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id...
Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...
Updated Aug 22, 2026
security-parametersLists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...
Updated Aug 18, 2026
security-parametersLists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...
Updated Aug 22, 2026
security-parametersLists the Ledgers the current user has direct data access to — used as the LOV source for a "Ledger" report parame...
Updated Aug 22, 2026
security-parametersLists the Fixed Asset Books the current user has data access to — used as the LOV source for a Fixed Assets report...
Updated Aug 22, 2026
security-parametersLists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...
Updated Aug 22, 2026
Guides filed under this topic.
Basic SELECTSELECT * FROM employees;SELECT Specific ColumnsSELECT id, name FROM employees;
ExampleSELECT * FROM employees WHERE salary > 50000;WHERE works with all DML operations to refine your target dataset.
Overview of SQL SyntaxStructured Query Language (SQL) is used to interact with relational databases. Each SQL statement...
SELECT StatementThe SELECT statement is used to query the database.SELECT first_name, last_name FROM employees;You can a...
FROM ClauseThe FROM clause defines the table from which to retrieve data.SELECT first_name FROM employees;You can join m...
WHERE ClauseThe WHERE clause is used to filter rows based on a condition.SELECT * FROM employees WHERE department_id = 5...
ORDER BY ClauseUse ORDER BY to sort results based on one or more columns.SELECT first_name, salary FROM employees ORDER...
DISTINCT KeywordDISTINCT is used to return only unique values.SELECT DISTINCT department_id FROM employees;You can use i...
Arithmetic Expressions and AliasesArithmeticSQL allows basic arithmetic operations:SELECT first_name, salary + 1000 AS u...