how to change the password to running user

by nagaraj
(bangalore)

hi... i need to know about some of my queries..

please tell me
1. how to change the password to running user?
2. how to increase the width of the column?
3.join the two tables display the dept no wise result as shown in the below tables
emp table( empno,empname,manager,sal, deptno) and dept table(deptno. deptname
)

Comments for how to change the password to running user

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 19, 2015
Rating
starstarstarstarstar
Answers
by: Anonymous

1. Use the ALTER USER command
eg. ALTER USER hr IDENTIFIED BY GerOnimO2015;

It's the same command whether you're changing the password for your own account or someone else's.

2. Use the ALTER TABLE MODIFY command
eg. ALTER TABLE emp MODIFY (empname VARCHAR2(90))

3. To join 2 tables you need to know which columns are equivalent in the 2 tables. Often they have the same name but not alwys. When you've figured that out just use a SELECT statement specifying the tables you wnat to join and the column name from each table that you're joining on.

In your question emp and dept tables both have a column called deptno so this is the column to join on. Therefore the SQL statement becomes something like the following:
SELECT empname,deptname
FROM emp,dept
WHERE dept.deptno=emp.deptno

Refer to the Oracle Database SQL Language Reference for the complete syntax for these commands. http://docs.oracle.com/database/121/SQLRF/toc.htm

The best way to acquire Oracle skills quickly and easily and cost-effectively is with online training. Follow this link to learn more about the online training offered by our partner GoGo Training http://gogotraining.com/ For a 5% discount on all training with them, enter the coupon "AskTheOracle" at the check out.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.