How to use "in out" parameter properly?
No Answer is Posted For this Question
Be the First to Post Answer
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How to best split csv strings in oracle 9i?
17. Display the order number and average item cost for each order.
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.
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What is the dynamic sql in oracle?
what is the syntax of UPDATE command?
How to create an oracle database manually?
What privilege is needed for a user to delete rows from tables in another schema?
What is transaction control statement and how many types of transaction control statement in Oracle?
How can I introduce multiple conditions in like operator?