Answer Posted / girija.112

ANS:
Only one outer join is possible for a single query & it can be
either left outer join or right outer join or full outer join.
We can't use two outer joins for a single query.

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2092

---

What is key preserved table?

969

---

How do I spool in oracle?

951

---

How to divide query output into groups in oracle?

949

---

What is a subquery in oracle?

1051

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2058

---

How to add a new column to an existing table with a default value?

975

---

What is oracle datasource?

931

---

How do I limit the number of oracle database connections generated by weblogic server?

1013

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1899

---

How to update values in a table in oracle?

967

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2103

---

How to define an anonymous procedure without variables?

1034

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1867

---

How to pass a cursor variable to a procedure?

1049

---