Answer Posted / subha

First compile package A and B spec then compile package body of both A and B.

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3550

---

Enlist the characteristics of pl/sql?

1244

---

What is aggregate function in sql?

538

---

What is the mutating table and constraining table?

561

---

Can we create index on primary key?

524

---

---

What are the types of queries in sql?

524

---

What is a sql statement?

533

---

What is materialized view. What are different methods of refresh?

782

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1684

---

What is an ndf file?

534

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

3348

---

What is compilation error in pl sql?

504

---

What is the difference between a subquery and a join?

529

---

what is recursive stored procedure? : Sql dba

529

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2070

---