呵呵sql

本文主要是介绍呵呵sql，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

INSERT  INTO fnd_document_folder_structure_t
(folder_name,parent_folder_id,company_type_id,inv_flag,con_flag,sup_flag,archives_flag,leaf_flag,creation_date,created_by,last_updated_date,last_updated_by)
SELECT
      '其他',(SELECT folder_id FROM fnd_document_folder_structure_t WHERE folder_name = '旁站监理记录'),'3','N','Y','Y','N','Y',NOW(),'0',NOW(),'0'
  FROM DUAL


DELETE FROM fnd_user_t WHERE user_name IN(

SELECT a.user_name FROM (SELECT fnd_user_t.* FROM fnd_user_t WHERE user_name LIKE '%测试%' OR user_name LIKE '%演示%'  OR user_name = '') a )

这篇关于呵呵sql的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---