. , , ,

,,,

Web - Oracle -Web (WOW) — ,

7.1

7.2

7.3

7.4

7.5

7.6 htp

7.1

- - WOW. SQL PL/SQL Oracle. Oracle. PL/SQL Oracle, "PL/SQL Users Guide and Reference". Oracle , "Oracle7 Server Administration Guide".

WOW Unix.

7.2

WOW WWW - (Web -) SQL - Oracle (-Oracle-) HTML - (-Web). , WOW Oracle - PL/SQL, SQL. . Oracle .

WOW - WWW - PL/SQL. , WWW - . , PL/SQL HTML. . 7-1.

7.3

, WOW , CGI PL/SQL (. . 7-2).

htp , HTML - . htf , HTML - .

7.4

. WOW 2Mb . :

  1. Unix;
  2. WWW - ;
  3. Oracle Oracle SQL*Net Oracle.

I

, , wowstub. wowstub Oracle SQL*Net. make Makefile. Makefile Oracle Unix:

  • ORACLE_HOME - , ORACLE_HOME Oracle.
  • DEST_DIR - , CGI WWW .
  • DOC_ROOT - WOW. WWW .

II

wowstub, Oracle.

  1. , WOW . WWW.
  2. . SQL , WOW: wow.sql, ht.sql, math.sql, emp.sql, showemp.sql, hanoi.sql. : SQL*Plus, SQL*DBA, Server Manager, Enterprize Manager.

III

wowstub CGI WWW . wow, sh:

  1. ORACLE_HOME - ORACLE_HOME Oracle SQL*Net;
  2. TWO_TASK - TWO_TASK Oracle;
  3. WOW_UID - , II .

, 4 : wow.win, wow.iso, wow.alt, wow.koi8.

wow ( 4 ) CGI - WWW .

7.5

WOW. WWW - www.cnit.nsu.ru URL:

http://www.cnit.nsu.ru/cgi-bin/wow.win/example.test?answer=no

(. . 7-3):

  1. WWW - CGI - wow.win.
  2. wow.win test example answer no, WWW Oracle.
  3. Oracle , . , HTML - , wow.win.
  4. wow.win Microsoft CodePage 1251, Windows - , WWW - .
  5. WWW - , , WWW - .

URL, PL/SQL :

  1. WOW, CGI - . wow - .koi8, .win, .iso, .alt WWW - :
    • -8
    • Microsoft Code Page 1251
    • ISO 8859-5
    • Microsoft Code Page 866

:
http://www.cnit.nsu.ru/cgi-bin/wow.win

  1. PL/SQL, . www Oracle. , PL/SQL - www . (test) www, :

http://www.cnit.nsu.ru/cgi-bin/wow.win/test

(example), www, :

http://www.cnit.nsu.ru/cgi-bin/wow.win/example.test

Oracle, . , fancy :

http://www.cnit.nsu.ru/cgi-bin/wow.win/fancy.example.test

www , GRANT SQL.

  1. , '?', :

<_> = <_>

, '&':

<_1>=<_1>&<_2>= <_2>

. . , . . .

, . , .

:
http://www.cnit.nsu.ru/cgi-bin/wow.win/example.test?answer=no

WOW PL/SQL - , WWW - .

  1. , WOW varchar2. - , varchar2.
  2. htp HTML - . <HTML> ... </HTML> , .

example:
Create or Replace package example is
procedure test(answer in Varchar2);
end;
/
Create or Replace package body example is
procedure test(answer in Varchar2) is
varchar2(3);
cursor c_man(ans in varchar2) is select from _ where =ans order by ;
begin
--
htp.p('<HTML>');
--
if answer = 'no'
then
:='';
htp.htitle(' , ');
else
:='';
htp.htitle(' , ');
end if;
htp.olistopen;
--
for man in c_man() loop
--
htp.item(man.);
end loop;
--
htp.olistclose;
--
htp.p('</HTML>');
end;
end;
/

WWW Oracle :

Create table _( varchar2(30),
varchar2(14),
varchar2(20),
varchar2(3));

WOW HTML. example .

<HTML>
<HEAD>
<TITLE> </TITLE>
</HEAD>
<BODY>
<H1> </H1>
<FORM ACTION="http://www.cnit.nsu.ru/cgi-bin/wow.win/example.test">
:<INPUT NAME="answer">
<INPUT VALUE="" TYPE="SUBMIT">
</FORM>
</BODY>
</HTML>

7.6 htp

procedure title(ctitle in varchar2)

- ( <TITLE>)

procedure htitle(ctitle in varchar2)

- ( <TITLE>, <H1>)

procedure header(nsize in integer, cheader in varchar2)

- nsize ( <H1> ... <H6>)

procedure url(curl in varchar2, cname in varchar2)

- cname , curl ( <A HREF>).

procedure gif(curl in varchar2)

- , curl ( <IMG>).

procedure gif(curl in varchar2, calign in varchar2)

- , curl , calign ( <IMG>).

procedure bold(ctext in varchar2)

- ctext ( <B>).

procedure italic(ctext in varchar2)

- ctext italic ( <I>)

procedure item(cval in varchar2)

- cval ( <ITEM>).

procedure formOpen(curl in varchar2)

- curl ( <FORM>).

procedure formHidden(cname in varchar2, cvalue in varchar2)

- cvalue cname.

procedure formPassword(cname in varchar2),
procedure formPassword(cname in varchar2, cvalue in varchar2)

- - cname cvalue.

procedure formField(cname in varchar2, nsize in integer),
procedure formField(cname in varchar2),
procedure formField(cname in varchar2, cvalue in varchar2)

- cname nsize cvalue.

procedure formText(cname in varchar2, nrow in integer, ncol in integer)

- ( ncol, nrow) cname.

procedure formCheckbox(cname in varchar2)

- checkbox cname.

procedure formRadio(cname in varchar2, cval in varchar2)

- radiobutton cval cname.

procedure formSelectOpen(cname in varchar2)

- cname.

procedure formSelectOption(cval in varchar2)

- cval , formSelectOpen.

procedure formSelectClose

- , formSelectOpen.

procedure formDo(cname in varchar2)

- SUBMIT cname.

procedure formDo

- SUBMIT 'Submit'.

procedure formUndo(cname in varchar2)

- RESET cname.

procedure formUndo

- RESET 'Reset'.

procedure formClose - .

:

procedure print (cbuf in varchar2),
procedure print (dbuf in date),
procedure print (nbuf in number)

 - .

print - p:

procedure p (cbuf in varchar2),
procedure p (dbuf in date),
procedure p (nbuf in number).

, :

procedure line

- ( <HR>).

procedure para

- ( <P>).

procedure nl

- ( <BR>).

procedure item

- ( <LI>).

procedure ulistOpen

- ( <UL>).

procedure ulistClose

- ( </UL>).

procedure olistOpen

- ( <OL>).

procedure olistClose

- ( </OL>).

procedure dlistOpen

- ( <DL>).

procedure dlistClose

- ( </DL>).

procedure dterm

- ( <DT>).

procedure ddef

- ( <DD>).

procedure preOpen - .
procedure preClose - .
7.1 7.2 7.3 7.4 7.5 7.6 htp 7.1 -

 

 

 

! , , , .
. , :