steveb. (1/18/2011)

---

even if you went with stored procedures you will still have to 'hard-code' the values somewhere. to me the opposite of hard-coding is to put the values...

GSquared (1/20/2011)

---

What I always recommend is, write down a list of questions you need answered about SQL Server, take the list to a bookstore, pull a stack of SQL books...

A view is nothing but a catalogued query you...

single row sub query returns more than one column

mmmhhh... I think message says "more than one row", isn't it?

If that's the case, that's exaclty what it is happening -...

Resender (1/20/2011)

---

OK in the past 72 hours I had 2 major successes involving oracle 11g

1)Working Oracle 11g R2 Enterprise on a SUSE Linux 11 SP1

2)Using SSIS to pump data from...

Let me start by saying that every single point you...

varunkum (1/13/2011)

---

DECODE(addr.pk_dynreport.f_chk_omit('ccard_auto_renew'),'Y', NULL, circ.subs_bill_util.ccard_status(account))

Guyz someone please hep me understand this sql above. I know the decode statement and addr&circ are databases. When i did

select * from addr.pk_dynreport.f_chk_omit

it said sql...

David Portas (1/12/2011)

---

PaulB-TheOneAndOnly (12/27/2010)

---

sawantpl@gmail.com (12/27/2010)

---

3- Different definitions of 1NF, 2NF and 3NF in different documents? really? I know there are good and bad documents in the net but failing to...

Gianluca Sartori (1/10/2011)

---

Agreed. Fortunately...

This is because of these are two independent, totally different implementations of the...

Building on Danilo's answer - please remember SYSDATE() returns the date down to the "second" therefore if you want whole dates you have to truncate the date by including TRUNC()...

veena.jokhakar (1/8/2011)

---

I want to creat a cube, i have goe through the business intelligence, but have still not understood when we slect the DSV data souse view, we select the...

Resender (1/7/2011)

---

The laptop has 3.8 GB of workable RAM, I configured the EXAMPLE(orlc) database to ma manual, I replaced the one I intend to use for testing and exercises with...

Resender (1/7/2011)

---

today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours

the best answer i can think off atm is...

Resender (1/5/2011)

---

One of the things i'm currently stuck at is savepoints

i create one

create savepoint a1;

but if i want to rollback to it i'm getting the ora-01086 saying its not established...