Page 1 of 1
SQL Query to check HOSTNAME
Posted: 22 Oct 2009 8:42
by rchkevin
What is the SQL Query to check the hostname in the DB
Re: SQL Query to check HOSTNAME
Posted: 22 Oct 2009 1:51
by YOWAL
rchkevin wrote:What is the SQL Query to check the hostname in the DB
HI
FOR EM
Select NODE_ID FROM DEF_JOB;
FOR CMS
Select NODEID FROM CMR_AJF;
Posted: 22 Oct 2009 2:02
by philmalmaison
wich kind of hostname ?
regards
philmalmaison
Posted: 22 Oct 2009 7:03
by rchkevin
Hostname of EM and CTM SERVER
Posted: 22 Oct 2009 7:07
by himanshu
SQL> sqlplus svctme64@ecspcor6
Enter password
SQL> select count(*) from commreg where CTLMACHINE='ctmdvsx103e'; <or> delete commreg where CTLMACHINE='ctmdvsx103e'; <or> commit;
Posted: 27 May 2011 9:20
by alexcamron
Hello friends I am college student and also Networking student. I'll create a website and I have a c-penal but have no idea about SQL DB. I want sms website but I am just understand HTML script. I am create sms website but it's not work for me because I am not set SQL so if you have tutorial or idea about this so please help me.
thanks in advance.