This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
code --list-extensions | xargs -L 1 echo code --install-extensions |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH MY_VIEW AS ( | |
SELECT FIELDNAME,LABEL18,ROWNUM AS ROWNUMBER | |
FROM ( | |
SELECT A.FIELDNAME,A.LABEL18 | |
FROM PS_FS_SD_RECFLD A | |
,PS_FS_SD_GRPFLD B | |
WHERE B.SD_GRP_NAME = 'VNDR_AUTH' | |
AND A.SD_RECNAME = 'VNDR_AUTH' | |
AND B.SD_RECNAME = A.SD_RECNAME | |
AND B.SD_FLDNAME = A.SD_FLDNAME |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# If you use the IB connector param SSLProtocols , then this will appear in the info. section of IB msglog.html file. | |
# For the web server, you can add these parameters to the 'JAVA_OPIONS_os' parameter in setEnv.sh/cmd and then check the logs. | |
# -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true -Dweblogic.security.SSL.verbose=true -Djavax.net.debug=all | |
#Here is an example: | |
SET JAVA_OPTIONS_WIN=-jrockit -XnoOpt -XXnoJITInline -Xms512m -Xmx512m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true -Dweblogic.security.SSL.verbose=true -Djavax.net.debug=all |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT B.PTCS_SERVICEID | |
,C.PORTAL_OBJNAME | |
,C.PORTAL_URI_SEG1 AS MENUNAME | |
,C.PORTAL_URI_SEG2 AS PNLGRPNAME | |
,C.PORTAL_URI_SEG3 AS MARKET | |
,B.PTCS_INSTANCELBL | |
,NVL((SELECT X.XLATLONGNAME | |
FROM PSXLATITEM X | |
WHERE X.FIELDNAME = 'PTCS_ISCOMPSERVICE' | |
AND X.FIELDVALUE = B.PTCS_ISCOMPSERVICE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WHENEVER SQLERROR EXIT SQL.SQLCODE; | |
WHENEVER OSERROR EXIT; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT DISTINCT Y.MENUNAME | |
,Y.COMPONENTNAME | |
,Y.MARKET | |
,Y.PORTAL_LABEL AS LABEL | |
,Y.PORTAL_OBJNAME | |
,Y.PORTAL_PRNTOBJNAME | |
,Y.PORTAL_CNTPRV_NAM | |
,Y.VERSION | |
,Y.PORTAL_URL_CHKSUM | |
,TO_CHAR(E.PORTAL_NAVPATH) AS PATHNAME |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH MY_TILE_NAV_COLL AS | |
( | |
/* This query provides the list of all tiles (CREF objects, CREF paths) and their | |
corresponding nav collection CREF object. */ | |
SELECT A.PTPPB_GROUPLET_ID AS TILE_NAME | |
,A.DESCR AS TILE_DESCRIPTION | |
,A.PTPPB_ORIG_DISP_ID AS TILE_CREF_OBJECT | |
,'Root > Fluid Structure and Content > Fluid Pages > ' || D.PORTAL_LABEL AS TILE_PATH | |
,C.PTPPB_VALUE AS NAV_COLL_CREF_OBJECT | |
FROM PS_PTPPB_GROUPLET A |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN ('UPM','SYS') | |
/ | |
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'UPM' | |
/ | |
DELETE FROM PSROLEUSER WHERE ROLEUSER = :1 AND ROLENAME LIKE '%%' | |
/ | |
UPDATE PSOPRDEFN SET VERSION = (SELECT VERSION | |
FROM PSVERSION | |
WHERE OBJECTTYPENAME = 'UPM' | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'QDM' | |
/ | |
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN ('QDM','SYS') | |
/ | |
UPDATE PSQRYDEFN SET VERSION = (SELECT VERSION FROM PSLOCK WHERE OBJECTTYPENAME = 'QDM') | |
WHERE OPRID = :1 | |
AND QRYNAME = :2 | |
/ | |
COMMIT | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
javascript:lpSwipeToTabFromDD(%27ERP.EMPLOYEE.MY_DEVELOPER_HOME%27); |
NewerOlder