Search results for query: *

Here is the output from a select statement: 1 select FCAT, TC, TT, VCAT, BOC, ENTRY , ACEV, DESCR, DB, CR, DB2, CR2, DB3, CR3, DB4, CR4, EDAT 2 from fms_glfcat 3 where fcat in ( 'V ' , 'NV') 4 AND ENTRY LIKE '1243%' 5* ORDER BY ENTRY, FCAT SQL> / FC TC TT V BOC ENTR ACEV DESCR...

Does anyone know how to write a script to count a record (T_NUM) once so that it is capture in the stats for the first date and excluded from all future dates? T_NUM EDATE ------------ --------- 797PR6005 05-DEC-06 797Q70015 05-DEC-06 797Q70015 06-DEC-06 797Q70015...

I need help fixing the update statement below. The update statement updates all of the records on the table for a specific day. This is not what I want to happen. I would like the cleared field updated with an ‘N’ if the concatenated fields is found in a subset of concatenated fields (ref...

I need an sql script to manage progress when thing are constantly changing. Below is a layout of the tmp_susf table and count of the records by date. Inside of this table are records from each day--some leaving and new ones added. Does anyone have an idea as to how to show progress or a lack...

Does anyone know how to create a PL/SQL script that will create a file for each USERID_2? The file will contain all records for a specific user. I would also like the file to be the name of the userid_2 (XXXXMW1). A copy of the table is as follows: EDATE USERID_2 B_ B_ B_NUM T_ AO T_NUM...

TABLE LAYOUT: ID NOT NULL NUMBER (38) LABEL NOT NULL NVARCHAR2 (60) PARENTID NOT NULL NUMBER (38) SELECT * FROM (SELECT sYear, sMonth, SUM(DataLoad) AS DataLoad, Entity, sAcct, sGovCode FROM (SELECT...