ccdm

Label:1. Export the table data to a TXT file:1 to /BRCB_EDP/DATA_PUBLIC_EDP/file/CCDM/file/ ofSelect* from PDM. File_ccdm_dr_card_cust_detExplain:/brcb_edp/data_public_edp/file/ccdm/file/file_ccdm_dr_card_cust_det.txt: Exported to the path and file name2. Import the TXT file data into the table:1 Load from /BRCB_EDP/DATA_PUBLIC_EDP/file/CCDM/file/ ofinsert in

sj_receiptinfo t WHERE t.TAXNO LIKE CONCAT('%', CONCAT(?, '%'))mysql：select T.* from sj_receiptinfo t WHERE t.TAXNO LIKE CONCAT('%', ？, '%') sqlServer：select T.* from sj_receiptinfo t WHERE t.TAXNO LIKE ‘%%’Postgresql:Select *, (T. Category Code | '-' | T. Invoice number) AS number from account where username ~ * 'Baidu ';Find out the information of all users in the account in the data table that contain baidu and are case insensitive.4. Judge nullOracle：SELECT ProductName,UnitPrice*(UnitsInS

job and take it for granted, the result will naturally be in vain. The interview was unsuccessful. He lost his original job and spent a lot of savings. He tried to find a job for two months under great pressure, and both his mind and body suffered heavy losses, it puts itself in great risk. To the ccdm expert group, the key to job success is to improve the competitiveness of the workplace. Find the matching points between your skills, expertise, and

t.TAXNO LIKE CONCAT('%', CONCAT(?, '%')) mysql：select T.* from sj_receiptinfo t WHERE t.TAXNO LIKE CONCAT('%', ？, '%') sqlServer：select T.* from sj_receiptinfo t WHERE t.TAXNO LIKE ‘%%’Postgresql:Select *, (T. Category Code | '-' | T. Invoice number) AS number from account where username ~ * 'Baidu ';Find out the information of all users in the account in the data table that contain baidu and are case insensitive.4. Judge nullOracle：SELECT ProductName,UnitPrice*(UnitsInStock+NVL(UnitsOnOrder

t.taxno like CONCAT ('% ',? , '% ')Sql server:Select t.* from Sj_receiptinfo T WHERE t.taxno like '% 'PostgreSQL: SELECT *, (T. Category Code | | '-' | | T. Invoice number) as number from the account where username ~* ' Baidu ';Find information about all user names in the data table account that contain Baidu and are case-insensitive4. Determine nullOracle: SELECT productname,unitprice* (unitsinstock+NVL(unitsonorder,0)) from ProductsMySQL: SELECT productname,unitprice* (unitsinstock+ifnull(u

Sj_receiptinfo T WHERE t.taxno like CONCAT ('% ', CONCAT (?, ‘%‘))MySQL: Select t.* from Sj_receiptinfo T WHERE t.taxno like CONCAT ('% ',? , '% ') Sql server:Select t.* from Sj_receiptinfo T WHERE t.taxno like '% 'PostgreSQL: SELECT *. (T. Category Code | | '-' | | T. Invoice number) as number from the account where username ~* ' Baidu ';Find information about all user names in the data table account, including Baidu and those that do not distinguish between uppercase and lowercase 4. Inf