answersLogoWhite

0

Basic commands in oracle

Updated: 11/6/2022
User Avatar

Wiki User

13y ago

Best Answer

See the list of Commands in Oracle

ANALYZE

AUDIT

CALL

CREATE CLUSTER

ALTER CLUSTER

DROP CLUSTER

COMMENT

COMMIT

CONNECT

CONSTRAINT

CREATE CONTEXT

DROP CONTEXT

CREATE CONTROLFILE

CREATE DATABASE

ALTER DATABASE

DELETE

DESCRIBE

CREATE DIMENSION

ALTER DIMENSION

DROP DIMENSION

CREATE DIRECTORY

DROP DIRECTORY

EXEC

EXECUTE IMMEDIATE

EXPLAIN PLAN

CREATE FUNCTION

ALTER FUNCTION

DROP FUNCTION

GRANT

CREATE INDEX

ALTER INDEX

DROP INDEX

CREATE INDEXTYPE

DROP INDEXTYPE

INSERT

INTERSECT

CREATE JAVA

ALTER JAVA

DROP JAVA

CREATE LIBRARY

DROP LIBRARY

CREATE DATABASE LINK

DROP DATABASE LINK

LOCK TABLE

CREATE MATERIALIZED VIEW

ALTER MATERIALIZED VIEW

DROP MATERIALIZED VIEW

CREATE MATERIALIZED VIEW LOG

ALTER MATERIALIZED VIEW LOG

DROP MATERIALIZED VIEW LOG

MINUS

NOAUDIT

CREATE OUTLINE

ALTER OUTLINE

DROP OUTLINE

CREATE PACKAGE/BODY

ALTER PACKAGE

DROP PACKAGE

CREATE PFILE

CREATE PROCEDURE

ALTER PROCEDURE

DROP PROCEDURE

CREATE PROFILE

ALTER PROFILE

DROP PROFILE

RECOVER

RENAME

ALTER RESOURCE COST

REVOKE

RMAN

CREATE ROLE

SET ROLE

ALTER ROLE

DROP ROLE

ROLLBACK

CREATE ROLLBACK SEGMENT

ALTER ROLLBACK SEGMENT

DROP ROLLBACK SEGMENT

SAVEPOINT

CREATE SCHEMA

SELECT

CREATE SEQUENCE

ALTER SEQUENCE

DROP SEQUENCE

ALTER SESSION

SHUTDOWN

SNAPSHOT

CREATE SPFILE

STARTUP

ASSOCIATE STATISTICS

DISASSOCIATE STATISTICS

CREATE SYNONYM

DROP SYNONYM

ALTER SYSTEM

CREATE TABLE

ALTER TABLE

DROP TABLE

CREATE TABLESPACE

ALTER TABLESPACE

DROP TABLESPACE

CREATE TEMPORARY TABLESPACE

SET TRANSACTION

CREATE TRIGGER

ALTER TRIGGER

DROP TRIGGER

TRUNCATE

UPDATE

UNION

CREATE USER

ALTER USER

DROP USER

CREATE VIEW

ALTER VIEW

DROP VIEW

WHERE

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Basic commands in oracle
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the common Linux commands by Oracle 10g?

Oracle 10g's commands are internal; they have nothing to do with what platform it is running on.


What are the Linux commands used by Oracle DBA?

ls


How many basic commands are there for dogs?

Basic commands are sit, stay, and lay down.


How the oracle is connected to java and visual basic?

Oracle is the company that owns Java and is partnered with Microsoft who owns Visual Basic.


What commands is used to add rows to a table in oracle 11g SQL?

INSERT


How do you get into Keller graduate school?

Yes, oracle financial services provides basic accounting services. Yes, oracle financial services provides basic accounting services. Yes, oracle financial services provides basic accounting services.aewr a


Where can one find a list of sqlplus commands?

A list of SQLplus commands is available on the Docs Oracle website. This website contains a summary table that briefly describes and lists SQLplus commands.


How many commands are there in AutoCad?

Billions and billions :)are you asking for the commands list or commands which are important and basic one......around 259= basic commands are their for autocad.and for the list please go with this link: http://academics.triton.edu/faculty/fheitzman/commands.html


What are some commands in GW-BASIC?

Some commands are Save, Load, Auto etc.


The three basic components of the ribbon are?

tabs, groups, and commands


Basic commands and position in gymnastics?

rrqfgt


How does one perform performance tuning in Oracle?

Tuning in Oracle is required in order to speed up computing times and to save money. Oracle will perform a test to determine what portions require tuning. From there various commands are used to tune ones system.