SQL>

SQL> set serveroutput on

SQL> declare

2 XXX varchar2(10);

3 MSG varchar2(50);

4 begin

5 XXX := '';

6 select decode(XXX,NULL,'IS...

That's a very good question indeed. I was...

Oh yes, you can but, a Null and an empty string will be both treated as Null

- insert a Null

- insert an empty-string

- insert a letter

- count nulls... two!

SQL> create...

Raunak Jhawar (10/14/2010)

---

I was reading an article presented by Kognitio recently. Now considering an enterprise approach is it feasible to take it's DW solutions to the cloud.

As far as I...

BowieRules! (10/18/2010)

---

No, I don't think so... Char data type is also a string data type, and person posting original question was looking for a way to distinguish between NULL and...

Since...

There is a particular privilege you must grant in Ora11g, don't you?

Does CREATE SESSION rings a bell?

:blink: Really?

SQL> select version from v$instance;

VERSION

-----------------

11.1.0.7.0

SQL>

SQL> variable XXX varchar2(20)

SQL> exec :XXX := ''

PL/SQL procedure successfully completed.

SQL> select :XXX from...

BowieRules! (10/15/2010)

---

I would add that it depends on how you define your string. If column is defined as varchar2(1) then empty string will be treated as NULL in Oracle. However,...

Lynn Pettis (10/15/2010)

---

PaulB-TheOneAndOnly (10/15/2010)

---

nick.mcdermaid (10/14/2010)

---

I'm impressed with Oracle packages as they almost seem like classes to me

-Variables which 'reflect' existing table meta data

-Custom data types

-Multiple 'methods' within the package all...

jeff.mason (10/15/2010)

---

PaulB-TheOneAndOnly (10/15/2010)

---

Steve Jones - SSC Editor (10/15/2010)

---

I would have thought so, but if people entered data in a new system, you can't restore without losing that data. So you...

...and...

Steve Jones - SSC Editor (10/15/2010)

---

I would have thought so, but if people entered data in a new system, you can't restore without losing that data. So you need to...

Richard McSharry (10/15/2010)

---

In the worst-case scenario where a critical bug has crept through QA, are there any software tools that assist in helping you rollback a database to a previous...

mpradeesh (10/15/2010)

---

Thanks, but if the records are keep on updating, so I will end up in 100s of records for the same Account in the same table and its too...