oracle grant all privileges to user

Tags: completion time desc name Ott des ESC composition cotIt is necessary to familiarize yourself with the four tables under this user.View all table names:SELECT * FROM tab;To view the structure of each table:DESC 表名称；1, Department table: DeptNo Name type description1 DEPTNO Number (2) department numbers, two digits.2 dname VARCHAR2 (14) department name, up to 14 characters3 LOC VARCHAR2 (13) Department location2. Employee table: EMPNo Name type des

--oracle See all of the user's table names, table comments, field names, field comments, empty, field type SELECT DISTINCT table_column.*, table_nallable. Data_type, table_nallable. NULLABLE from (SELECT DISTINCT Utc.table_name table_name, utc.comments table_comments, Ucc.column_name column_name, ucc.comments column_comments from User_tab _comments UTC, User_col_comments UCC where utc

--oracle See all the user's table names, table gaze, field name, field gaze, is empty, field type SELECT DISTINCT table_column.*, table_nallable. Data_type, table_nallable. NULLABLE from (SELECT DISTINCT Utc.table_name table_name, utc.comments table_comments, Ucc.column_name column_name, ucc.comments column_comments from User_tab _comments UTC, User_col_comments UCC where utc.table_na