Answer / ayan banerjee

create user user_name identified by password

then

grant resource to user_name

grant create session to user_name

Answer / guruswamy

create user <username> IDENTIFIED BY password;

Answer / satyajit patel

If u later want to change the password then go to the
database where the user is created and write

ALTER USER user_name IDENTIFIED BY new_password;

Which is faster subquery or join?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---

what are the methods using performance tunning in sql and pl/sql

2 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What is difference between stored function and application function?

0 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---

How to process query result in pl/sql?

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

Can I join the same table twice?

0 Answers  

---

What is mutating trigger?

0 Answers  

---