Creating a user if it does not already exists using one SQL scrip

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Fri, 30 Jun 2000 08:27:16 +0200
Message-Id: <10543.110874@fatcity.com>

How can I create a user using a sql script not PL/SQL by testing if it already exists before issuing the CREATE USER command. Am I obliged to use a dynamic sql statements in a PL/SQL block or is there a simple method only by using SQL ?

---

---

@biy @lemu
Cril Telecom Software
France Received on Fri Jun 30 2000 - 01:27:16 CDT