Oracle Development

number of week days

How do i find out the number of weekdays in a date range in oracle.

Searching using Oracle Forms 6i

Hello i am using forms 6i.I have a form where I am working on some DMLs. When I enter data in text items and press save button, all the records inserted successfully. On save button there is commit_form on When_Button_Pressed trigger. The problem is when I open the same form, search for a specific...

Oracle Forms 6i

Hi... I am trying to connect to Oracle database using Forms6i.... But it is asking database name.. I am giving Global database name.. and LOGIN is not accepted... How can I solve this Problem....... Please give necessary suggestions to LOGIN and how can i find Database names in Oracle.....?

VC++: int keyword gives different results in Oracle 9i and 10g

In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, any...

$$PLSQL_UNIT

Dear All, I know that using the $$PLSQL_UNIT i can get the current procedure executing. but there is a problem when i use it to get the procedure name inside the package. it only returns the Package name not the procedure name. how can i get the PACKAGE.PROCEDUE_NAME please help .. Ahmad Saeed...

ALTER INDEX statement

'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code ,...

Search for a keyword in all columns of all database tables

Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data...

I need to permanently delete a re-generating job, but I can't find its source

I have used dbms_job.remove to remove all jobs from dba_jobs, but something is re-submitting a series of jobs every few minutes. I have disabled all triggers and all external cron jobs have been stopped... but more jobs keep getting submitted. I have a single transaction record in v$transaction...

SQL statement exceeding 2000 characters in Oracle Graphics Builder

In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.

How to perform Unique check in PL/SQL

Hi Experts, I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before inserting new record into Table XX Table XX for combination of the following field list (X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0 How can i do this...

How to make or check the attribute (location) in PL/SQL block?

Hi Experts, How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block Thanks for the help

Bulk Collect vs Cursor in Oracle

Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table...

Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following

I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was...

Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following

I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able...

SQL select

SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE --(UPPER(log.resolution(+)) like '%'||obj.object_name||'%' -- and trunc(log.resolution_date(+)) - trunc(to_date(substr(obj.last_ddl_time,1,11),'dd-mon-yy')) <=5 -- and...

Oracle Forms

how to show oracle form at run time full screen

FND_RESP_FUNCTIONS

Is there an API or a script I could use to make massive inserts into FND_RESP_FUNCTIONS?

Searching using Oracle Forms

Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text item and enter...

Develop Oracle application by 4GL

i am good devoloper in 4gl under informix under platform unix i tranfer to oracle 10g under window 2003 server would you please give me tools to write my own 4gl program in using oracle database under windows

IN PL/SQL how to declare and use 'STATIC DATA TYPE like C'

Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will...