UMBC CMSC 461 Spring '99 | CSEE | 461 | 461 S'99 | lectures | news | Oracle Help | help |
SQL> select owner, table_name 2 from all_tables; OWNER TABLE_NAME ------------------------------ ------------------------------ SYS DUAL SYS SYSTEM_PRIVILEGE_MAP SYS TABLE_PRIVILEGE_MAP SYS STMT_AUDIT_OPTION_MAP SYS AUDIT_ACTIONS SYS PSTUBTBL SYSTEM DEF$_TEMP$LOB BURT CUSTOMER BURT BRANCH BURT ACCOUNT BURT DEPOSITOR 11 rows selected.
SQL> desc account Name Null? Type ------------------------------- -------- ---- ACCOUNT_NUMBER NOT NULL CHAR(10) BRANCH_NAME CHAR(15) BALANCE NUMBER(12,2)
SQL> desc account Name Null? Type ------------------------------- -------- ---- ACCOUNT_NUMBER NOT NULL CHAR(10) BRANCH_NAME CHAR(15) BALANCE NUMBER(12,2) SQL> DESC account Name Null? Type ------------------------------- -------- ---- ACCOUNT_NUMBER NOT NULL CHAR(10) BRANCH_NAME CHAR(15) BALANCE NUMBER(12,2) SQL> DESC ACCOUNT Name Null? Type ------------------------------- -------- ---- ACCOUNT_NUMBER NOT NULL CHAR(10) BRANCH_NAME CHAR(15) BALANCE NUMBER(12,2) SQL> insert into account values ('A-23', 'Perryville', 1200.00); 1 row created. SQL> INSERT INTO ACCOUNT VALUES ('A-24', 'Perryville', 600); 1 row created.
SQL> select * from account; ACCOUNT_NU BRANCH_NAME BALANCE ---------- --------------- ---------- A-23 Perryville 1200 A-24 Perryville 600 SQL> select * 2 from account; ACCOUNT_NU BRANCH_NAME BALANCE ---------- --------------- ---------- A-23 Perryville 1200 A-24 Perryville 600
grant connect to
Example:
grant connect to burt identfied by gizmo;To execute a stored procedure named register without any arguments:
To execute a stored procedure named register with one argument:
When you use CREATE to create a stored procedure, a message appears if there are compilation errors. To view these errors, you use SHOW ERRORS. For example, if you were trying to compile a procedure with the name of assignvl and got a message like: