Answer / Nivedita

If the binary SPFILE for the default instance is wrong, you can create a new one or restore it from a backup. To create a new one, follow these steps:

1. Connect to the database as SYSDBA: `sqlplus / as sysdba`
2. Create a new SPFILE using the CREATE SPFILE FROM DBA_REGISTER_FILE command: `CREATE SPFILE FROM DBA_REGISTER_FILE;`
3. Check the location and content of the newly created SPFILE.

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

How to count duplicated values in a column in oracle?

1 Answers  

---

How do you bind variables in oracle?

1 Answers  

---

What is flashback in Oracle?

1 Answers   MCN Solutions,

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 Answers  

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

Differentiate between pre-select and pre-query?

1 Answers  

---

How to rename an existing table?

1 Answers  

---

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

---

How to update values in a table in oracle?

1 Answers  

---

What is blob data type in oracle?

1 Answers  

---