Specs for Portal Preferences


Specifications for Portal Preferences

Back to the Conceptual Data Model.

Step 1 : Register as a new User.

Code to display stored Tutorials in 'documents2' table in Oracle. ***

Personalization Options.

Example of Page to be generated from Database.

In Oracle :-
SQL> describe users;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                                  NOT NULL VARCHAR2(50)
 PASSWORD                                           VARCHAR2(50)
 EMAIL                                              VARCHAR2(100)

SQL> select * from users;
USERNAME PASSWORD EMAIL
---------------------------------------------
barryw   miami3   barryw@gmisystems.com
bdimple  miami3   bdimple@databaseanswers.com

ORACLE :-

DEFINITION OF THE documents2 Table :-
SQL> describe documents2;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DOCUMENT_CODE                             NOT NULL CHAR(10)
 DOCUMENT_TYPE_CODE                                 CHAR(13)
 DOCUMENT_TITLE                                     VARCHAR2(50)
 DOCUMENT_URL                                       VARCHAR2(255)
 DOCUMENT_DESCRIPTION                               VARCHAR2(255)
                     

DATA IN THE documents2 TABLE :-
SQL> select document_code from documents2;

DOCUMENT_CODE
-------------
DB_DESIGN
INSTAL_9I
SOP_FRG

[ Home Page | Ask Us a Question | Email Us | FAQs | Search & Site Map ]