Oracle周日：放松身心，体验科技乐趣（oracle周日）

文 | 林慧宁

跟着科技发展步伐，今日的人们生活节奏愈加快速，而一方面来讲，科技也创造更多便利及新鲜体验，今回，就隆重推介Oracle周日，带来智能技术新体验，休闲娱乐放松，感受科技的温暖陪伴。

Oracle周日不单单只提供一些虚拟游戏体验，而是学习Oracle技术，开发简单的实用程式码，就可以让虚拟世界变得更加有趣、动感。

比如说“芳芳python聊天机器人”，让python语言带来更多有趣及实用的聊天机器人，比如如果用户输入任何一句话，它可以自动检测出问题关键词，进而回复让用户想要的答案。例如下列程序码：

import re 
 
def respond(message): 
    # Check for a question mark 
    if message.endswith("?"): 
        # Return a random question 
        return " that's a good question!"
    # Return a random statement 
    return "That's interesting!" 
 
# Define a dictionary with the predefined responses 
bot_template = "BOT : {0}" 
user_template = "USER : {0}"
 
# Define a function that sends a message to the bot: send_message
def send_message(message):
    # Print user_template including the user_message 
    print(user_template.format(message)) 
    # Get the bot's response to the message 
    response = respond(message) 
    # Print the bot template including the bot's response. 
    print(bot_template.format(response)) 
 
 # Send a message to the bot 
send_message("What's for dinner tonight?") 

而使用者也可以学习定点数据，如R女士，学习到如何建立Oracle数据库，以及如何进行管理：

--1. Create the customer table
CREATE TABLE customer (
  customer_id NUMBER(7) NOT NULL,
  first_name VARCHAR2(50) NOT NULL,
  last_name VARCHAR2(50) NOT NULL
);

--2. Create a package to store the customer records
CREATE OR REPLACE PACKAGE customer_pkg AS
  PROCEDURE add_customer(cust_id_in IN customer.customer_id%TYPE,
                         first_name_in IN customer.first_name%TYPE,
                         last_name_in IN customer.last_name%TYPE);

  FUNCTION get_customer_count RETURN NUMBER;  
END customer_pkg;
/

--3. Create the package bodies 
CREATE OR REPLACE PACKAGE BODY customer_pkg AS
  PROCEDURE add_customer(cust_id_in IN customer.customer_id%TYPE,
                         first_name_in IN customer.first_name%TYPE,
                         last_name_in IN customer.last_name%TYPE) AS
  BEGIN
    INSERT INTO customer (customer_id, first_name, last_name)
    VALUES (cust_id_in, first_name_in, last_name_in);
  END add_customer;

  FUNCTION get_customer_count RETURN NUMBER IS
    cnt NUMBER;
  BEGIN
    SELECT COUNT(*) INTO cnt
    FROM customer;
    RETURN cnt;
  END get_customer_count;
END customer_pkg;
/

无论你再忙碌，Oracle周日都能帮你找回放松的心情。透过玩乐让我们可以更有活力，快来享受今日的Oracle周日吧！