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;

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

Enlist some predefined exceptions?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

What is a sql profiler?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

What are the types of triggers in sql?

0 Answers  

---

Can we commit in trigger?

0 Answers  

---

Can we create index on primary key?

0 Answers  

---