Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions

Question

Explain why a large fi rm could not use a simple structure.

Answered: 1 week ago