Ahmad Zayed

Labels: Me

Hi Folks

It was from a while. I didn't write anything in my blogs because I have exam's and a lot of assignment to do.

Today I have to work on Oracle 9i but the service stop immediately after starting. I don't know why but I remembered that I changed the computer name so everything goes wrong after searching I found the answer

You have to change hostname to the new one in the following files.

·       tnsnames.ora

·       sqlnet.ora

·       listener.ora

And delete all *.q file inside network/agent folder

Thanks to Oracle Forum

Have fun

Bye

Hi

Today at Arab Teem someone ask question about the null and the Space-Key which is not null of course. See this example to know more what I'm talking about.

Have fun.

Bye

Create Table xT

(

FName VarChar ( 30 ) Not Null

)

Go

Insert into xT ( FName ) Values ( Null )

Go

Insert into xT ( FName ) Values ( '' )

Go

Insert into xT ( FName ) Values ( 'Ahamd' )

Go

Alter Table xT With NoCheck

Add Constraint CH_xT_FName Check ( Len ( FName ) > 0 )

Go

Insert into xT ( FName ) Values ( Null )

Go

Insert into xT ( FName ) Values ( '' )

Go

Insert into xT ( FName ) Values ( 'Desigen' )

Go

Select * From xT

Go

Labels: Sql Server

Hi Folks

I have been recently looking for a UML tool and I found this cool tool designed by

• Omar AL Zabir(site)
• Shahedul Huq Khandkar
• Mehfuz Hossain
• Awnik Raihan

Have fun.

Bye

Labels: UML