what is pragma?
Answers were Sorted based on User's Feedback
Answer / svj
PRAGMA (also called pseudo instructions) is the keyword
that signifies that the statement is a compiler directive,
which is not processed when PL/SQL block is executed.
Rather,it directs the PL/SQL compiler to interpret all
occurrences of the exception name within the block as the
associated Oracle server error number.
| Is This Answer Correct ? | 1 Yes | 0 No |
How many file formats are supported to export data?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
what is integrity constrains?
Respected sir, Please send me technical questions related to oracle apps..
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is oracle instant client?
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 to create a temporary table in oracle?
hai, when to use char and varchar2....?