Search results for query: *

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...

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...

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 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...

Is it possible to execute multiple bcp commands after one has just completed.

I do not know if this is possible, however I will ask the question? Is it possible to schedule, one BCP to run and execute, finish successfully and then execute another BCP command to run after the first one has run? I am extracting 74 tables and views. One BCP per table or view. ie, BCP...

There was a sql 2000 server installed on server with a cluster. However the cluster crashed and failed. I am now trying re-install sql 2000 on the server but it is trying to find the previous sql 2000 database attached to the server. Please can anybody tell me how I can uninstall sql 2000...

I have mapped drives to a sql server 2000 machines and I was wondering if it is physically possible to make sql 2000 to see mapped drives. I know he can see physical drives.

I am running a schedulded job to delete files older than 12 months. Would creating a stored procedure be the best option and schedule this job. Please could I have some advice on how to recognise files from getdate() to 12 months.

Please could anybody recognise this message, it occurs when running sql scripts or bcp. Could not allocate new page for database tempdb. There are no more pages available in filegroup default. Space can be created by dropping objects, adding additional files, or allowing file growth. Please...

I am converting a date but it coming out as YYYY-MM-DD, I am trying to convert the date to display as dd/mm/yyyy with "/" but not quite there can you help!!!! This is what I am using: +'|'+ISNULL(CONVERT(VARCHAR10),NTCKnownFacts.Date_of_Birth,120),'')

I am getting errors trying to extend tempdb. Tempdb is already set to 3500 but I am running into problems when I run the bcp command. There are 50 million records in one table and is fails to export the full amount of records and bcp fails at 1 million records with the error "unable to...

Hello, I have records be inserted into a table, what I would like to do is delete the records in the table on the last day of the month, I am not sure what the sql script is to find the last day of the month. Can you help?

I doing large amount of extractions from our SQL 2000 server to oracle. There is a field in sql (text field), when you select the max(datalength) on the field it comes to 984989. This field contains XML coding with return characters, <> characters etc. The destination field in oracle is a...

I am doing an extraction from sql 2000 to oracle, but I have a field that contains dates, but has been defined as an char value. I would like to find all dates and null values and replace with a valid date, but I need some assistance with the replace. The datefield is a char field but contains...