![]() In Order to create a table in the Oracle database, you must have CREATE TABLE system privilege in your schema, and CREATE ANY TABLE system privilege to create a new table in another user’s schema. SQL> INSERT INTO student VALUES(1011, 'EMMA') ġ011 EMMA Create a Table in Another Schema SQL> INSERT INTO student VALUES(1010, 'OLIVIA') To insert data into details we must use the INSERT statement which is discussed in detail Oracle INSERT statement. Since we only created the table that’s why it is empty. To display the table data we must use SELECT query, it will display all column names and its data. The DESC command gives information about the table like column names, its data type, and the column has NOT NULL constraint or not. It is a SQL *Plus tool-specific command i.e. To view the structure of the table we are using the DESC command. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |