Answer / nishi

Oracle Call Interface is a method of accesing database from a 3GL program. Uses-- No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides

-functions to parse SQL statemets

-bind input variables

-bind output variables

-execute statements

-fetch the results

What are various joins used while writing SUBQUERIES?

2 Answers  

---

how to genarate random numbers in oracle for particular row?

3 Answers  

---

Point out the difference between user tables and data dictionary?

0 Answers  

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers  

---

What is raw datatype?

0 Answers  

---

---

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  

---

what is integrity constrains?

3 Answers  

---

what is null value?

11 Answers   KITS, Oracle,

---

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

how to make an oracle object

0 Answers  

---