提高 SQL 编写效率的技巧和窍门 [THR2919].pdf

1、Productivity Tips and Tricks for Writing SQLTHR2919Chris SaxonDeveloper A following is intended to outline our general product direction.It is intended for information purposes only,and may not be incorporated into any contract.It is not a commitment to deliver any material,code,or functionality,and

2、 should not be relied upon in making purchasing decisions.The development,release,timing,and pricing of any features or functionality described for Oracles products may change and remains at the sole discretion of Oracle Corporation.3Copyright 2025,Oracle and/or its affiliates|I thought AI would hel

3、p with this?Have you seen our data model?4Copyright 2025,Oracle and/or its affiliates|Cant we just use AI?Have you seen our schema?create table university_data(data_id integer,number1 number,number2 number,date1 date,string1 varchar2(4000),data json,)5Copyright 2025,Oracle and/or its affiliates|Buil

4、d productivity foundationsNamingMake purpose clearNormalizingPrevent data anomaliesConstrainingEnhance data qualityCopyright 2025,Oracle and/or its affiliates|6Choose Good NamesClearCommon nounsOne meaningConciseShort as possibleLong as neededConsistentThe same concept=same nameCopyright 2025,Oracle

5、 and/or its affiliates|8How NOT to name your tables9Copyright 2025,Oracle and/or its affiliates|EDUCANDS SESSIONSUNIVERSITY PUPIL COURSE REGISTRATIONRareAmbiguousInconsistentInconsistentLooooooooong10Copyright 2025,Oracle and/or its affiliates|STUDENTS CLASSESSTUDENT CLASSESWhat about our existing s

6、chema?11Copyright 2025,Oracle and/or its affiliates|What about legacy schemas?create table university_data(data_id integer,number1 number,number2 number,date1 date,string1 varchar2(4000),data json,)12Copyright 2025,Oracle and/or its affiliates|rename table university_data to student_classes;alter ta