Oracle Development

Inserting 50000 rows using FORALL statement

How can we insert 50000 rows by using FORALL,please give me entire code?

Where are Oracle Anonymous Blocks stored?

Where the anonymous blocks are stored?

PL/SQL

Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...

Errors in Creating Oracle packages

Can anybody plz find out the error in the following code?? plz reply back. SQL> CREATE OR REPLACE package body PKG_IMAGEM1 2 as 3 PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, 4 P_College IN VARCHAR2, 5 P_CourseCat in varchar2, 6 P_CourseName in...

PL/SQL - Attribute to test not null and can take specific value instead

Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

Oracle vs Java programming

Which is better Oracle or Java? I have a interest in programming. What should I learn?

PL/SQL error

Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

Need help creating a specific Oracle View

We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would...

Oracle Data Dictionary

I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this...

How to call trigger stored in database using Oracle Forms

how to call trigger stored in database using oracle forms

Oracle Forms 10g - Disable the save button in PDF as well as in IE

hi, i am using forms10g and i called a report using web.show_document which was successful rep_url:='/reports/rwservlet?destype=cache&desformat=pdf&report=z:/test/item_status_y.rdf&userid=test/test@oracle¶mform=yes'; web.show_document(rep_url,'_blank'); The report was generated in PDF which...

Define array in Oracle

i have coulumb stn varchar2(100) , i want to split it to 4 columbs n1 varcha2(20)...n4 varchar2(20) ,depend on space eg: stn : John Adms Smith Zac n1 : John n2 : Adms n3 : Smith n4 : Zac i use oracle8.0.5 developer6

Need help with Oracle query

how to display the third highest salary from an employees table thanks in advance

Oracle Forms 6i - Execute query

Execute_query is not refreshing the data from a currently active block but Execute_query is refreshing a different block. I have given go_block pointing to one block. But execute_query is refershing a differnt block. Please suggest.

Oracle 10g Reports not running

Hi Gurus, We are trying to migrate from form and reports 4.5 to 10g and while migrating them we were able to find the way to work with forms 10g but not with reports 10g from within forms. can any one give me the procedure to make reports 10g to work within forms . with example please.

Oracle - Deleting a row from a complex view

why we can delete a row from a complex view if it does not contains group by clause,group functions,distinct keywords,pseudocolumn

Query for tab canvas block

I have a Form with a tab canvas for the detail and a multi row master block. when scrolling through the rows in the master block the detail block (tab canvas) isnot executing the query (only by steping on the detail block is the query preformed)

PL/SQL Insert

Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400...

Lotus Notes to Oracle

i have a field (date)i want to insert date(field) in oracle table .i used"+doc.date(0)+"but date is not inserted in oracle table . how can it possible .pls suggest me.

I am getting ORA-01422: Exact fetch returns more than requested number of rows

Hi Experts, I am gettting this error when i run my test case for my PL/SQL procedure ,which hav select and Insert statement only ,not clear where i wud hav went wrong,please guide me where should i check exactly its poping this error message which i catched in exception piece after Insert statement