↓ Skip to Main Content
Oracle Help & Docs
Oracle Database commands & functions by example
Home
DBA
ALTER SYSTEM
ANALYZE
AUDIT
CATALOG
DBA TASKS
DEPENDENCIES
EXPLAIN PLAN
EXPORT
HINTS
SHUTDOWN
STARTUP
TRACE
TUNNING
Users
ALTER USER
CREATE PROFILE
CREATE ROLE
CREATE USER
DROP USER
GRANT
REVOKE
DDL
ALTER TABLE
COMMENT
CONSTRAINTS
CREATE DATABASE
CREATE GLOBAL TEMPORARY TABLE
CREATE INDEX
CREATE ROLLBACK SEGMENT
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE VIEW
DATATYPES
RENAME
STORAGE
DML
COMMIT
DELETE
INSERT
LOCK TABLE
ROLLBACK
SAVEPOINT
SELECT
TRUNCATE
UNION
UPDATE
WHERE
PL/SQL
CASE
CURSOR
DESCRIBE
EXCEPTION
EXECUTE
EXECUTE IMMEDIATE
FUNCTION
IF
LOOP
PROCEDURE
SQLCODE
SQLERRM
String functions
ASCII
CHR
CONCAT
CONCAT OPERATOR “||”
CONVERT
INITCAP
INSTR
LENGTH
LOWER
LPAD
LTRIM
REPLACE
RPAD
RTRIM
SOUNDEX
SUBSTR
TRANSLATE
TRIM
UPPER
VSIZE
Group by functions
AVG
COUNT
MAX
MIN
STDDEV
SUM
Date functions
ADD_MONTHS
CURRENT_DATE
CURRENT_TIMESTAMP
LAST_DAY
MONTHS_BETWEEN
NEXT_DAY
ROUND
TRUNC
Number functions
ABS
CEIL
EXTRACT
FLOOR
GREATEST
LEAST
MOD
REMAINDER
ROUND
SIGN
TRUNC
Conversion functions
CASE
DECODE
NULLIF
NVL
NVL2
TO_CHAR
TO_DATE
TO_NUMBER
SQLPLUS
CALL
SET
System functions
DUAL Table
NLS_SESSION_PARAMETERS Table
ROWID Column
ROWNUM Column
SYSDATE
SYS_CONTEXT
USER
USERENV
Common errors
ORA-00001
ORA-00041
Home
›
DBA
›
DBA TASKS
DBA TASKS
Search for:
Commands
NLS_SESSION_PARAMETERS Table
LOCK TABLE
CREATE PROFILE
USERENV
LEAST
CREATE SYNONYM
CREATE GLOBAL TEMPORARY TABLE
VSIZE
CEIL
EXECUTE IMMEDIATE
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.
Accept
Read More
Privacy & Cookies Policy