Question: 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

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!

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...

can you please help me complete this al Add Dog: Write a stored procedure to add a dog. Pass 5 parameter values: owner s ID , date of birth, name, breed, and weight. Use a sequence to generate an ID...

sql =====================================table sql===================================== use APC Create TABLE EMPLOYEE ( EmployeeNumber int NOT NULL IDENTITY (1,1), FirstName Char(25) NOT NULL,...

Hello, I'm new to php and the professor i have isnt good at teaching the class. I'm wondering if anyone can help me with the following problem. I created the entire html but i dont understand how to...

Hello, can anyone help me with this problem. I'm not quite sure how to do this at all. Objectives: To acquaint you with PHP file handling, HTML forms, arrays, strings, and control structures Tasks:...

Use the diagram of the sample Class File System directory tree to assist with this lab. Step 1. Open the terminal window Click Start->All Programs->PuTTY(64-bit) folder->PuTTY icon enter "ubuntu"...

Write a stored procedure to add a dog. Pass 5 parameter values: owner s ID , date of birth, name, breed, and weight. Use a sequence to generate an ID for the dog being added. Write a stored procedure...

IP SESSION MA CIS485CookieExerc PHPSessionScripts cis485Exam03New PHP SESSIONMySQl Stores hosted cuny.edu/webapps/blackboard/content/listContent,jsp?course icd Purpose: Practice creation of stored...

Chapter 1 7 How to manage database security Exercises 1 . Write a script that creates a user - defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission...

Write a program that creates a login username for a user, given the user's first name, last name, and a four-digit integer identification number as input. A username is made up of the first five...

Draw the shear and moment diagrams forbeam. 50 Ib/ft 200 Ib - ft 9 t ft

Moody and three other people bought a business together and executed promissory notes for $8.17 million to be repaid on a certain schedule. For his contribution, Moody owned 20 percent of the...

35. Which statement is the most accurate? (LO6) a) The 21st century will almost defi nitely be another American Century. b) The 21st, rather than the 20th, will be called The American Century. c) The...

The two broad groups that non - profit organizations serve are clients and _ _ _ _ _ _ _ _ . Multiple Choice audiences customers donors beneficiaries

8. List and briefly explain each of the five steps in the training process.pg 87

3. What are some typical on-the-job training techniques? What do you think are some of the main drawbacks of relying on informal on-the-job training for breaking new employees into their jobs?pg 87

7. What is organizational development and how does it differ from traditional approaches to organizational change?pg 87