Excel formula to make scripts in Oracle

="update saa_resp_strat set login_ach='"&B5& "' where cfam='"&A5&"' AND creg='AR'"

Como Verificar o Oracle instalado é 32 ou 64 bits ??

agpadm@frparux7:/home/agpadm>cd $ORACLE_HOME
agpadm@frparux7:/oracle/product/8.1.7_64>cd bin
agpadm@frparux7:/oracle/product/8.1.7_64/bin>file oracle
oracle: module exÚcutable ou objet AIX Ó 64 bits non rÚduit

Removing world from tnsnames

Using 8i, you may come across to this

you cant connect to the database if you dont put xxx.world in you TNSnames

So


If you dont want to use the default domain name go to
sqlnet.ora file D:\Oracle\Ora81\network\ADMIN\sqlnet.ora
if oracle 8i or in oracle8 in \network\ADMIN\sqlnet.ora

remove the NAMES.DEFAULT_DOMAIN or disable it with # before the parameter.

then ||rly comeback to tnsnames.ora file edit and remove the word WORLD.

TEST.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = padmam)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)