0
Still curious? Ask our experts.
Chat with our AI personalities
Devin
Professor
ViviAdd your answer:
Earn +20 pts
Which cursor attribute do you reference to determine the number of records that were deleted by a DELETE statement?
Sql%rowcount
What can a SQL UPDATE statement allow one to do within a table?
A SQL UPDATE statement allows the user to update existing records in a database table. For example, it could be used to update a customer's address, or a the price of a product.
What is the difference between delete and truncate statement in SQL Database?
Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table. Drop deletes the table itself.
What are the sql commands with dml and ddl?
The DDL provides statement for the creation and deletion of tables, indexes, views etc. The DML provides statements to enter, update, delete and perform complex queries on these tables.
What are the main function in sql?
SQL (Structured Query Language) is a language used in a SQL server to manage data (Query the data, insert, Update, Delete) as well as perform data manipulation (calculations, etc)
