Answer / dhivya

select * from v$session;

from this we can get the user's id.

Answer / lakshmi narayanan r

SELECT CURRENT_USER

Answer / ajitnayak

select USERNAME,user_id from user_USERS;

Answer / dinesh sharma

select User_Id()

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

1 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

In which database can extended stored procedures be added?

0 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

Can an extended stored procedure be called from inside a user-defined function?

0 Answers  

---

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  

---

What is DB Development software?

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---

How long can an error message be in raiseerror function?

0 Answers  

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

0 Answers  

---