Oracle AI 数据库 SQL 和 PL_SQL 的新特性 [LRN2875].pdf

1、Whats New in Oracle AI Database SQL and PL/SQLLRN2875Chris 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,a

2、nd 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.2Copyright 2025,Oracle and/or its affiliates|Invalid statements3C

3、opyright 2025,Oracle and/or its affiliates|Whats wrong with these?-Add sensor for Ayr,Scotlandinsert into sensors(latitude,longitude)values(-4.6204,55.4525);4Copyright 2025,Oracle and/or its affiliates|-Add test datainsert into sensor_readingsselect sensor_id,temperature_in_c,reading_timestampfrom s

4、ensors cross join generate_sensor_readings(200);5Copyright 2025,Oracle and/or its affiliates|-Average temps in C&F in 15-minute groupsselect trunc(reading_ts)+floor(reading_ts-trunc(reading_ts)/(60/12),mi)*15 grp,avg(temperature_in_c)avg_in_c,avg(temperature_in_c*5/9-32)avg_in_ffrom sensor_datagroup

5、 by reading_ts;6Copyright 2025,Oracle and/or its affiliates|-Readings mean temperatureselect*from sensor_readingshaving temperature_in_c avg(temperature_in_c);7Copyright 2025,Oracle and/or its affiliates|8Copyright 2025,Oracle and/or its affiliates|Lets run them&find out!DEMO9Copyright 2025,Oracle a

6、nd/or its affiliates|Whats New in Oracle AI Database SQL and PL/SQLLRN2875Chris SaxonDeveloper A of Oracle AI Database Release Updates23.26 Oct 2523.9 Jul 2523.8 Apr 2523.7 Jan 2523.6 Oct 2423.5 Jul 24GA May 2411Copyright 2025,Oracle and/or its affiliates|Apply Oct RU to becomeOracle AI Database 26a