chocolim.com

Todos los clientes con el mismo zip code

Posted by chocolim on agosto 12th, 2010

Interesante self-join

SELECT c2.name
FROM customer c, customer c2
WHERE c.customer_id = 648 AND
c.zipcode = c2.zipcode;

Posted by chocolim on junio 3rd, 2008

Para cambiar el password del usuario actual, loguearse a la consola y:

alter user user_name identified by new_password;

Donde user_name es el user que se esta utilizando.
Y new_password es la contraseña deseada.

You are currently browsing the archives for the Oracle category.