Search results for query: *

That okay, but it is how I write the plsql to accept the parameters from the field data into the button search.

I would really appreciate some help, if possible.

I have used to_char(flightdate, 'DD-MON-YYYY') I can now search on one single field as the field declared as a varchar2(11), but cannot search between two dates to retrieve all flights between the departure date and return date. Can you provide any suggestions.

I have tried changing them from date to varchar. I can search using it as char. Oracle forms Yes. The date filed is date in oracle and the search field set as date or varchar.

I know the sql should do some like this but I cannot get the search to recognise between the two text fields on the form. ie DATE1 DATE2 SEARCH SELECT .... WHERE DATE BETWEEN DATE1 AND DATE2;

Hello I would like to create a search button (push button) that will allow the user to input two dates and search fields between two dates. I have be able to do this successfully when search for numeric fields but not sure how to code the pl/sql (when-button push) for the dates, here a sample...

Hello, I am trying to insert sequence_id when a new record is created, but not sure the best way to tackle this. i.e., create squence seq_passenger_id increment by 1 start with 1 order; I have try to create ON BUTTON PRESS "WHEN CREATE RECORD" select seq_passenger_id.nextval into...

I have been trying to develop a rollover button in oracle forms 6i can this be done.

I am not sure if this is the best section to ask about oracle forms. I have download Oracle9iAS Forms Srvices and Oracle Forms Developer 6i RElease 2 for WIN 2000/XP. When I have installed it, it comes with oracle 8 version but this fails to work. Could the forms work with oracle 10g or any...

Hello could you clarify on the "ANSI joins" since it will be more readable, and like vongrunt said you probably can eliminate the temp table. I have tried to rewrite this but the temporary table seems to give it a better peformance I cannot get it to perform slightly better. Any suggestions

Thank you for your help, yes it is only the date (one date) that needs to run.

I was wondering if the procedure below could be changed to improve the performance. CREATE PROCEDURE spGetMailQueue (@CurrentDate datetime, @HOD varchar(3)) AS CREATE TABLE #PrintQueue (QueueNo int primary key, PCDID int, Stationary varchar(50)) INSERT INTO #PrintQueue SELECT...

PL/SQL I have a pl/sql but rather than use sequence I would like to use variables. I know it would be something like this: IN_CNT NUMBER(5):=0; IN_CNT:=IN_CNT +1;

Please could some advise how to re-code this changing from a sequence to a variable and add one. DROP SEQUENCE TRACKINGEXTRACT_SEQ; CREATE SEQUENCE TRACKINGEXTRACT_SEQ START WITH 7 INCREMENT BY 1 MINVALUE 1 MAXVALUE 7 CYCLE NOCACHE ORDER ; CURSOR next_seq_crsr IS select...

I have written a pl sql using the utl_file package. I am still experiencing problems with the clob field, however I found that there are only three clob fields that reach the maximum of 40000 and the rest are about 32k or below (so I can work with clob fields less than 32 k). The clob field...

could you give me an example of how this would work.

I have some clob fields that need to extracted to csv file but some of these fields are bigger than 40000 in length. I have tried packages such as dbms_lob.substr(clobfield), but this is limited to 4000. Any suggestions!!!

I am trying to extract a field that contains XML coding, includes spaces etc and this is defined as a clob field. Is there any way I can extract this field so that all the formatting is retained when viewed in a csv. This is going to be imported into an other database so I need to retain all...

I thought I would ask the experts a question first. I have some data that I need to extract on a daily basis from cron tab. I am spooling this data out to a "|" file, file.csv, but I am having problems with the clob field. Some of my Oracle DBA colleagues have mentioned packages such as...

Thank you for your comments, I have 74 views created. Each bcp execute the views individually as the views are complicated table joins. Some of the views contain 90 million of records. I have created the view first and then execute the view using the bcp command. Is it possible, ie., above...