#DateForumTypeThreadPost
722 Feb 2008 @ 04:21 PSTAnalyticsReplyconversion of oracle code into TeradataHi, How can i change the following oracle code into Teradata...PROMPT CAMPAIGN NM,CAMPAIGN CD,FLOWCHART NM,CELL CD,COUNTSELECT '"'||campaign_nm||'","'|| campaign_cd||'","'|| flowchart_n...
621 Feb 2008 @ 05:27 PSTAnalyticsTopicconversion of oracle code into TeradataHi, Please convert the following oracle code into Teradata...Thanks in advance.SET HEAD OFF;SET FEEDBACK ON;SET LINESIZE 32767;SET PAGESIZE 50000;PROMPT CAMPAIGN NM,CAMPAIGN CD,FLOWCHART NM,CELL...
518 Feb 2008 @ 12:19 PSTConnectivityReplyCONVERT MERGE STATMENT INTO UPSERT STATMENTHi,THANKS to your valuable reply for the merge statement...
413 Feb 2008 @ 02:19 PSTConnectivityTopicEquivalent of %TYPE and %ROWTYPE in teradataHello All,In oracle Both %TYPE and %ROWTYPE are used to define variables inPL/SQL as it is defined within the database. If the datatype orprecision of a column changes, the program automically pick...
313 Feb 2008 @ 02:16 PSTAnalyticsTopicEquivalent of %TYPE and %ROWTYPE in teradataHello All,In oracle Both %TYPE and %ROWTYPE are used to define variables inPL/SQL as it is defined within the database. If the datatype orprecision of a column changes, the program automically pick...
213 Feb 2008 @ 12:42 PSTConnectivityTopicCONVERT MERGE STATMENT INTO UPSERT STATMENTHi,CAn any body help me out to convert the below MERGE statement into UPSERT Statment(in teradata)...MERGE INTO cop_best_email plUSING(SELECTb.prs_cd_id, b.apple_id, b.effective_update_date,b.date_...
112 Feb 2008 @ 01:36 PSTConnectivityTopicCONVERT THE MERGE STATEMENT INTO UPSERT STATEMENTMERGE INTO cop_best_email pl USING (SELECT b.prs_cd_id, b.apple_id, b.effective_update_date, b.date_create, b.date_update, b.email_address, ...