forestq
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by forestq
-
-
Hi I have simply select and works great:
select 'CARAT Issue Open' issue_comment, i.issue_id, i.issue_status, i.issue_title, i.ISSUE_summary ,i.issue_description, i.severity,gcrs.Area_name, gcrs.sector_name,substr(gcrs.stream_name,1,case when instr(gcrs.stream_name,' (')=0 then 100 else instr(gcrs.stream_name,' (')-1 end) ISSUE_DIVISION,case when gcrs.STREAM_NAME like 'NON-GT%' THEN 'NON-GT' ELSE gcrs.STREAM_NAME END as ISSUE_DIVISION_2from table(f_carat_issues_as_of('31/MAR/2013')) iinner join v_gcrs_with_stream gcrs on i.segment_id = gcrs.segment_idwhere UPPER(ISSUE_STATUS) like '%OPEN%'
Now I want to callte two columns: ISSUE_DIVISION and ISSUE_DIVISION_2 if they are equal in new columns should be value 1 if are not equal should be 0, how can I do it ?
ORA delete / truncate
in SQL
Posted
Hi, I'm using SQL loader to load my data into database. Before I insert the data I need to remove existing data in the table:
But I got error like: SQL*LOADER-926: OCI error while executing delete/truncate <due to REPLACE/TRUNCATE keyword> for table IMPORT_ABCORA-30036: unable to extend segment by 8 in undo tablespace 'undo1' How can I delete data for example by 10000 rows?I know that I have some limit on my DB.