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 is specified along with the values to be inserted in the table. Here in the table Students the values inserted …

Executing INSERT statements in SQL plus Executing queries using SQL plus on Oracle database 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 7.8 The above figure executes the update query on the table students where a certain city is updated based on …

Executing queries using UPDATE statements 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 The fig 7.11 shows how this delete command is executed and the results are shown. Fig 7.11 The above figure …

Executing queries using DELETE statements Read More »

Scroll to Top