课堂练习_1（Class exercise _1）.docVIP

课堂练习_1（Class exercise _1） Practice on class 1 (mainly practice using some editing and execution commands of SQL*PLUS) 1, RUN, simplified R, or / Is used to list and execute the current SQL command stored in the buffer Example: SQL select * from student; SQL RUN 1* select * from student; 2, LIST simplified L Lists the contents of the current buffer, which is used primarily to list the wrong SQL statements when we make a SQL statement so that they can be modified LIST n lists the lines of the SQL statement. LIST m, n lists the lines and lines of the SQL statement. 3, CHANGE simplified C Edit rows listed by the LIST command. Usage: CHANGE old text / new text 4, DEL Delete a row listed by the LIST n command 5, APPEND simplified A Add text at the end of a row 6, CLEAR, BUFFER, abbreviated CL, BUFF Delete all rows CREATE, USER, username, identified, by, password; GRANT, connect, resource, to, username; Practice in class 2 One exercise is familiar with some of the common commands of oracel sql*plus. 1, connection SQL*Plus system/manager 2, displays the current connection user SQL show user 3, check which users the system has SQL select * from all_users; 4, new users and authorization SQL create user OA identified by 111; (default is built in SYSTEM tablespace) SQL, grant, connect, resource, to, oa; 5, connect to new users SQL conn a/a 6. Query all objects under current user SQL select * from tab; 7, establish the first table SQL, create, table, a (a, number); 8, query table structure SQL desc a 9 insert new record SQL, insert, into, a, values (1); 10, query records SQL select * from tablename; 11. Change the record SQL, update, tablename, set, a=2, where, id=?; 12, delete records SQL, delete, from, tablename, where, id=?; *********************************** / / create table space Create tablespace test_data Logging DatafileD:\oracle11g\oradata\test_data01.dbf Size 32m AUTOEXTEND on Next 32m maxsize 2048m Extent management local; / / insert data (***************************