Skip to main content

String Concatenation || generate cURL from select query 

 SELECT  'curl '
  ||'https://www.testapp.net/test/SupportClass!actionClass.action '
  ||'-H '
  ||'Origin: https://www.testapp.net '
  ||'-H '
  ||'Accept-Encoding: gzip, deflate '
  ||'-H '
  ||'Accept-Language: en-US,en;q=0.8 '
  ||'-H '
  ||'User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.87 Safari/537.36 '
  ||'-H '
  ||'Content-Type: application/x-www-form-urlencoded; charset=UTF-8 '
  ||'-H '
  ||'Accept: */* '
  ||'-H '
  ||'Referer: https://www.testapp.net/test/application.jsp '
  ||'-H '
  ||'Cookie: JSESSIONID=5C30005FF6BF00A2FDD18A3C0E258115.app-2; JSESSIONID=QIPalPyhOP2D8HMlGSl7Uw**.node1; SSOID=be2bb104392d40c4a4fea96162906b10; pnctest=1 '
  ||'-H '
  ||'Connection: keep-alive '
  ||'--data '
  ||'_operationType=update'
  ||'_operationId='
  ||'colID='
  ||A.COLUMN01,
  'nameCol='
  ||A.COLUMN02,
  'AddressCol='
  ||A.COLUMN03,
  'CityCol='
  ||B.COLUMN01,
  'passwordCol='
  ||A.COLUMN04,
  ' --compressed'
FROM TABLE01 A
INNER JOIN TABLE02 B
ON A.COLUMN_06=B.COLUMN02
WHERE CONDITIONS;

Comments

Post a Comment

Popular posts from this blog

Insert script with multiple cursors and condition check

DECLARE CURSOR C1 IS   SELECT ID FROM TABLE_NAME_1 WHERE COLUMN IN ('');   CURSOR C2     IS       SELECT ID FROM TABLE_NAME_2 WHERE COLUMN IN ('');              CURSOR C3 (CP_TABLE_01_ID NUMBER,CP_TABLE_02_ID NUMBER)         IS           SELECT COUNT(*) AS COUNT_UP           FROM TABLE_NAME_3           WHERE COLUMN_CONDITION_01=CP_TABLE_02_ID           AND COLUMN_CONDITION_02=CP_TABLE_01_ID; COUNT_UP NUMBER; BEGIN FOR R1 IN C1 LOOP     FOR R2 IN C2     LOOP          OPEN C3(R1.ID,R2.ID);        FETCH C3 INTO COUNT_UP;        CLOSE C3;               IF (COUNT_UP=0) THEN           INSERT           INTO TABL...
Post a Comment
Read more

REF Cursor

REF CURSOR WILL BE DYNAMICALLY OPENS OR OPEN BASED ON A LOGIC. DECLARE TYPE C1 IS REF CURSOR ; CURSOR C IS SELECT * FROM DUAL; REF_CURSOR RC; BEGIN IF (TO_CHAR(SYSDATE, 'DD' ) = 30 ) THEN OPEN REF_CURSOR FOR 'SELECT * FROM TABLE1' ; ELSIF ( TO_CHAR(SYSDATE, 'DD' ) = 29 ) THEN OPEN REF_CURSOR FOR SELECT * FROM TABLE2; ELSE OPEN REF_CURSOR FOR SELECT * FROM DUAL; END IF ; OPEN C; END ;
Post a Comment
Read more