Executing CREATE statements in SQL plus We can execute the create table in an Oracle database in which we have to specify the columns that need to be created along with the datatypes for various …
Read More »Executing queries using SQL plus on Oracle database
Executing INSERT statements in SQL plus Executing queries using SQL plus on Oracle database
Executing INSERT statements in SQL plus The insert statement is used to insert data in the Oracle database through the SQL INSERT command. Fig 7.2 The above figure shows the INSERT command being executed where the table …
Read More »Executing the select queries in SQL plus
The select queries is used to fetch the data from the database .We can also use FROM to fetch the data from the table based on certain selection or condition. The below figure shows how …
Read More »Executing queries using UPDATE statements
Executing queries using UPDATE statements The update query is used to update certain records in the table based on a certain condition or expression. We can execute the update statement as in Fig 7.8 Fig …
Read More »Executing queries using DELETE statements
Executing queries using DELETE statements The delete statement is used to delete certain records from the table based on a certain condition or expression. Fig 7.10 shows how to execute the delete statement. Fig 7.10 …
Read More »EXECUTING queries USING DROP statement.
EXECUTING queries USING DROP statement. The drop statement is used to drop a table from a database using the SQL plus query interface. Fig 7.12 shows how this statement is executed to drop a table. …
Read More »