Answer / manoj

DECLARE
v_date DATE;
v_char VARCHAR2(10);
v_number NUMBER;
BEGIN
NULL;
END;

Answer / anuram

CREATE OR REPLACE PROCEDURE PROCEDURENAME{(PARAMETERSLIST)}
AUTHID|CURRENT_USER
IS/AS
DECLARATION OF VARIABLES;
BEGIN
STATEMENTS;
EXCEPTION
STATEMENTS;
END PROCEDURENAME;

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

0 Answers  

---

Explain the role of indexing in databases?

0 Answers  

---

can you give me the syntax of named procedure??

2 Answers  

---

Write short notes on manual refreshes.

0 Answers  

---

explain detail about ftp in datastage?

0 Answers   IBM,

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Explain what a database is?

0 Answers  

---

What is DB Development software?

0 Answers  

---

How to generate OIDS

0 Answers  

---

Explain the rollup operator?

0 Answers  

---

What is the system function to get the current user's user id?

4 Answers  

---