What is tuple in sql?
How will you make performance better for application including front end and back
What is scalar data type in pl sql?
What happens when a trigger is associated to a view?
What is embedded sql in db2?
if we give update table_name set column_name= default. what will happen?
Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#
what is External tables? explain with examples
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
What version is sql?
What are the syntax and use of the coalesce function?