Question: 2 . Write a stored procedure SER _ LOGINS to create login id for user based on user first name and institute name in

2. Write a stored procedure "SER_LOGINS" to create login id for user based on user first name and institute name in "USERS" table. The pattern of the login id should be "@.in". The details of the fields are as given below:
(i) USER_ID (integer type)
(ii) FIRST_NAME (character data type of length 20)
(iii) INST_NAME (character data type of length 20)
(iv) LOGIN_ID (character data type of length 50)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!