What's dateware house and what's clustor with practicle example

2173

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2139

---

what is the diffrence between core dba and apps dba?

2568

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2181

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2241

---

what is insert all statement in sql

6512

---

Explain the architecture models of SQL Server?

2336

---

how can you connect from 10g user to 11g user??

2111

---

which background process invoke at the time of upgradation tell me???

2727

---

why not null is not allowed at table level

2757

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2014

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2831

---

what is tkprof tool and how it is used???

2829

---

I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

2171

---