Using Toad to operate Oracle

The Toad for Oracle tool was used in further projects. It was easy to use. Although there were too many things stacked on the interface, it felt a little messy, but it was actually quite helpful.

After logging on to the database, you can use the Schema Browser button to View information about the database, such as Table, View, Fuction, Procedure, and Package.

I tried to write the function in it and found that the function can only be written in the corresponding function. The package is also a bit awkward. But it's okay to get used to it.

Some test code (simple, only test Toad ):

1. ---- create a function

CREATE OR REPLACE FUNCTION SYSTEM.pan_func(name number) RETURN NUMBER ISpanno NUMBER;BEGIN   --panno := 0;   select seq into panno from help where seq=name;         RETURN panno;   EXCEPTION     WHEN NO_DATA_FOUND THEN       NULL;     WHEN OTHERS THEN       -- Consider logging the error and then re-raise       RAISE;END pan_func;/

2. ---- create a package

Create or replace package system. pan_package is procedure pan_procedure1 (name number); function pan_func1 (name number) return number; end ;/-- The following is the body.Create or replace package body SYSTEM. pan_package is procedure pan_procedure1 (name number) is begin update help set info ='Jiuuu'Where seq = name; end; function pan_func1 (name number) return number is haisa number; begin select seq into haisa from help where seq = name; return haisa; end; END;-- Pan_package;/