Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries. ANSWER:
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
class Main { public static void main(String[] args) { // f is to ensures that numbers are float DATA TYPE float f1 = 1.5f; float f2 = 2.0f; // to store the multiplied value float p = f1 * f2; // to print the product System.out.println("The product is: " + p); } }
class Main {
public static void main(String[] args)
{
// f is to ensures that numbers are float DATA TYPE
float f1 = 1.5f;
float f2 = 2.0f;
// to store the multiplied value
float p = f1 * f2;
// to print the product
System.out.println("The product is: " + p);
}
}
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
https://sikshapath.in/question/create-a-row-trigger-which-ensures-that-whenever-salary-is-updated-in-the-emp-table-then-some-message-is-displayed-to-the-user-and-if-new-salary-is-lesser-than-old-salary-display-the-difference-betwe/
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries. ANSWER:
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
ANSWER:
See lessWrite a trigger to ensure that no employee of age less than 25 can be inserted in the database.
Write a trigger to ensure that no employee of age less than 25 can be inserted in the database. ANSWER:
Write a trigger to ensure that no employee of age less than 25 can be inserted in the database.
ANSWER:
See lessCreate a trigger which will work before deletion in employee table and print a message “Deletion started”
Create a trigger which will work before deletion in employee table and print a message “Deletion started” ANSWER:
Create a trigger which will work before deletion in employee table and print a message “Deletion started”
ANSWER:
See lesstriggers
create table client(sno number(10), fname varchar(20), eid number(10), passwrd varchar(20)); . . . . . . . . . . . . TAP ON THE ATTACHMENT BUTTON FOR FULL ANSWER:
create table client(sno number(10),
fname varchar(20),
eid number(10),
passwrd varchar(20)); . . . . . . . . . . . .
TAP ON THE ATTACHMENT BUTTON FOR FULL ANSWER:
See lessThe float class is a wrapper class for the primitive type float which contains several methods to effectively deal with a float value
class Main { public static void main(String[] args) { // f is to ensures that numbers are float DATA TYPE float f1 = 1.5f; float f2 = 2.0f; // to store the multiplied value float p = f1 * f2; // to print the product System.out.println("The product is: " + p); } }
class Main { public static void main(String[] args) { // f is to ensures that numbers are float DATA TYPE float f1 = 1.5f; float f2 = 2.0f; // to store the multiplied value float p = f1 * f2; // to print the product System.out.println("The product is: " + p); } }See less