Question 1 give the structure of plsql blocks and, Ask an Expert

Engineering

Question 1. Give the structure of PL/SQL Blocks and explain

Question 2. Differentiate between PL/SQL functions and procedures

Question 3. Explain the following

Parameter file
Archive files

Question 4. Write about enterprise manager

Question 5. Explain the properties of Transaction?

Question 6. Write a small note on RMAN repository

Question 7. Write a cursor to open an employee database and fetch the employee record whose age is greater than 55

Question 8. Write a P/L SQL code to update employee table by calculating bonus for the sales target between

80 to 100-50%
60 to 80 -40%
40 to 60-30%
<40-25%

Using case statement

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M9588101

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Question suppose that you receive an email from someone

Question : Suppose that you receive an email from someone claiming to be Alice, and the email included a digital certificate that contains M = ("Alice", Alice's public key) and [h(M)]_CA, where CA is a certificate author ...

Select an appropriate data structure for each problem below

Select an appropriate data structure for each problem below. For each, write the name of the type of each data structure (queue, for example). Declare the structure using C code, and draw a picture of the structure. dict ...

Command to move all the sh files from current folder to

Command to move all the .sh files from current folder to parent directory. (single line Unix)

Ambrose has indifference curves with the equation x2 k -

Ambrose has indifference curves with the equation x2 = k - 4(x^0.5) ... Where the larger "k" is, the higher the indifference curve. If good 1 is drawn on the horizontal axis, and good 2 on the vertical... What is the SLO ...

Question read the following topic then explain where a

Question: Read the following topic then explain Where a datagram can be fragmented? Where the fragmented datagram can be reassembled? Fragmentation of Datagram Packets used by the IP are called datagrams. For a networks ...

There are sorted sequences l1 and l2 with 5 and 4 elements

There are sorted sequences L1 and L2, with 5 and 4 elements respectively. a) How many comparisons will it take to merge L1 and L2 in the best case? How many for worst case? Explain your answers. b) Let [54, 26, 93, 17, 7 ...

Consider the labor market of the telecom industry is

Consider the labor market of the telecom industry is originally at an equilibrium level E0 and w0. Assume that now the companies offer each employee an iPhone as employment benefit every year. The firms can get iPhone at ...

A simple substitution cipher can be created by shifting a

A simple substitution cipher can be created by shifting a letter n positions in alphabetic order. For example, if the possible characters are the list [A...Za...z], a shift of three would translate A to D and Z to c. The ...

Carbonated drinks like cola tonic water and club soda are

Carbonated drinks like cola, tonic water and club soda are pleasantly bubbly due to the following decomposition of carbonic acid: H2CO3(aq) → H2O(l) + CO2(g) If a sample of H2CO3 decomposes over water at 50°C, 0.23 L of ...

Question list and describe two forms of organizational

Question: List and describe two forms of organizational change. How does organizational change create business innovation? Give an example. Reply substantively to two other learners with thought provoking statements and ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert