Drop synonym drop public synonym command

580	SQL Developer (continued)	converting to mixed case, 335–336
580
		determining the number of characters in, 340
		extracting substrings from, 336–338
	SQL statement terminator (;), 31	inserting single quotation marks in, 146–147


	executing: in SQL Developer, 29, 64n, 70tip, 524–526	replacing single characters in, 343

scripts; SQL commands
SQL TRACE feature, 534
SQL Tuning Advisor, 534, 537
SQL*Loader, 529–532
SQL*Net statistics, 539, 539–540t
SQL*Plus, 16, 519, 519–522
column alias displays, 389n
commands. See SQL*Plus commands
entering statements: with the editing commands, 521–522
in the text editor, 521
executing queries, 520
interface, 27, 28, 32n
login, 519–520
scripts, 28tip, 155tip
START keyword replacement character (@), 28tip.

See also substitution variables
SQL*Plus commands:
CHANGE command, 522
PASSWORD command, 225. See also DESCRIBE command

START WITH clause (CREATE MATERIALIZED VIEW extracting from character strings, 336–338

command), 500 searching for, 338–339

statistical group functions, 403–405 subtotals: generating, 405, 407–416

statistics: database object statistics, 536. See also SUM function, 384t, 386–388, 417t

Index

FOREIGN KEY, 106, 108, 127t

PRIMARY KEY, 103, 127t	DROP USER command, 214t, 234, 235t

ALTER INDEX command … RENAME TO, 177t, 207t
ALTER ROLE command, 215t, 230, 236t
ALTER SEQUENCE command, 176t, 185–186, 206t	command, 89t
ALTER TABLE command, 70	FOREIGN KEY constraint, 106, 108, 127t
ALTER TABLE … ADD command: adding columns,

	GROUP BY extensions, 385t, 419t
127–128t
ALTER TABLE … DISABLE/ENABLE CONSTRAINT

ALTER TABLE … DROP COLUMN command, 75, 88t	INITCAP function, 335
ALTER TABLE … DROP UNUSED COLUMNS	INSERT INTO statements, 139–140, 166t

ALTER TABLE … MODIFY command, 71
	JOIN … USING method, 320t
ALTER TABLE … SET UNUSED [COLUMN]	LENGTH function, 340

ALTER USER command, 214t, 215t, 224, 229, 235t,
	LOCK TABLE command, 162, 166t
arithmetic operations, 50t	LOWER function, 333
AS keyword, 50t
AS keyword, 50t
AVG function, 384t, 388, 418t
Cartesian joins, 321t
CHECK constraint, 112, 127–128t
COMMIT command, 166t	MIN function, 384t, 394, 418t
CONCAT function, 344	modifying columns, 88t
CONCAT function, 344
concatenating columns/fields, 50t
correlated subqueries, 460t
correlated subqueries, 460t
COUNT function, 384t, 390, 418t
CREATE BITMAP INDEX command, 176t, 206t
CREATE BITMAP INDEX command, 176t, 206t	non-equality joins, 321t
CREATE INDEX command, 176t, 206t	non-equality joins, 321t
CREATE MATERIALIZED VIEW command, 474t, 503t	NOT NULL constraint, 115, 128t
CREATE MATERIALIZED VIEW command, 474t, 503t
CREATE OR REPLACE VIEW command, 474t, 475,


CREATE ROLE command, 215t, 226, 236t
CREATE SEQUENCE command, 176t, 178, 206t	POWER function, 348
CREATE SYNONYM (CREATE PUBLIC SYNONYM)	PRIMARY KEY constraint, 103, 126–127t

CREATE SYNONYM command, 202
CREATE TABLE command, 63, 88t, 126–128t
and ORGANIZATION INDEX, 177t, 206t	REVOKE command, 214t, 215t, 232, 236t
CREATE TABLE … AS command, 68, 88t
CREATE USER command, 214t, 216, 235t
CREATE VIEW command, 474t, 474–475, 502t
creating constraints, 102, 126–128t
CUBE extension, 385t, 419t	ROUND function (number), 344
DECODE function, 367	RPAD function, 341–342