-
Can you add not null column to a table already containing data ?
Radha
- Jul 13th, 2011
Yes we can add NOT NULL constraint for the column already containing data as: If the data doesn't have null values then - Alter table modify constraint ; If the data contains null values...
monoranjang
- Jan 24th, 2011
Yes possible, try the below query:ALTER TABLE test add c1 VARCHAR2(10) DEFAULT ('a') not nullThanksMonoranjan
-
PL SQL Procedure in Package
Procedure in package perfomes fastly over normal procedure, Explain.
monoranjang
- Jan 24th, 2011
A Storeprocedure is a Set of transactional SQL statements which will do some operation. Storedprocedure is precomplied . When we use sp's in our application it will reduce network traffic because ...
muraligrandhi
- Jun 8th, 2010
It's true. Procedures in the packages are faster than the stand alone procedures, because all the procedures in the package are compiled once and stored in the SGA at shared pool area. If we call the ...
