CREATE DATABASE LINK IN SQLPLUS

Tìm thấy 10,000 tài liệu liên quan tới từ khóa "CREATE DATABASE LINK IN SQLPLUS":

Khóa luận the research of using epad technology to support activities in administrative system

KHÓA LUẬN THE RESEARCH OF USING EPAD TECHNOLOGY TO SUPPORT ACTIVITIES IN ADMINISTRATIVE SYSTEM

c52. View task schedule 3.4. Use case diagrams and description 3.4.1. Login package Figure 1. Login use case Uc1. Login to system Use case name Login Actor Employee, Administration department, manager Purpose Access to main panel based on the right of user General description User type username and password into login form References R1.1 Process description Action Response 1. Access system through Internet via browser 2. Show login form 3. Type username and password 4. Show result: login successfully or not 5. Show main panel with functions based on type of user Exception User profile is not store in database Uc2. Authentication check Use case name Authentication check Actor Employee, Administration department, manager Purpose Check if username and password is valid General description System will compare username and password with user profile stored in database References R1.2, R2.2 Process description Action Response 1. Click on Login button 2. Show system’s message about user Exception User profile is not store in database 3.4.2. Logout package Figure 2. Logout use case Use case description: Uc3. Logout of system Use case name Logout Actor Employee, Administration department, manager Purpose Exit from system General description User click on Logout button and exit References R.2.1 Process description Action Response 1. Click on Logout button 2. Show message confirm if user want to logout of system 3. User choose OK 4. Exit from system Exception No exception Uc4. Authentication check Use case name Authentication check Actor Employee, Administration department, manager Purpose Check if username and password is valid General description System will compare username and password with user profile stored in database References R1.2, R2.2 Process description Action Response 1. Click on Logout button 2. Clear session of user Exception 3.4.3. User management package Figure 3. User management use case User management package description: Uc5. Create user Use case name Create user Actor Administration department Purpose Create new user General description Insert new user profile and then store profile into database References R.3.1 Process description Action Response 1. Click “Create user” button 2. Show user profile form 3. After inserting, click on “submit” button 4. Store user profile into database Exception User is already stored in database. Show message require reinsert information. Missing some information fields. Show message require fill in missing fields. Uc6. Edit user profile Use case name Edit user profile Actor Administration department Purpose Edit user profile General description Access to profile form and change some fields of the form References R.3.2. Process description Action Response 1. Click on “Edit user” button 2. Show user profile form Change fields appear in the form and click “Submit” Store user profile into database Exception Missing some information fields. Show message require fill in missing fields. Uc7. View user profile Use case name View user profile Actor Administration department Purpose View user profile General description Open user list and choose user, view user profile References R.3.3. Process description Action Response Choose user from user list Show user list 3. Click on “View user profile” button 4. Show user profile Exception Uc8. Delete user Use case name Delete user Actor Administration department Purpose Delete user from system General description Choose user from user list and delete user References R.3.4. Process description Action Response 1. Choose user from user list 2. Show user list Click on “Delete user” button Delete user from database Exception 3.4.4. New incoming document processing package Figure 4. New incoming document package Use case description: Uc9. Register to “incoming book” Use case name Register to “incoming book” Actor Administration department Purpose Register to “incoming book” General description Insert document’s information into “incoming book” form and store into database References R.4.1 Process description Action Response 1. Click on “incoming book” button 2. Show information form Insert document’s information and click “Submit” Store into database Exception Missing some fields in the form. Require fill in missing fields Uc10. Store into database Use case name Store into database Actor Administration department Purpose Store document into database General description Attach document into the form and upload into database References R.4.2. Process description Action Response 1. Browse files and click “submit” 2. Upload file and show result message Exception Connection error. Show message require browse files and update again. Uc11. View new incoming document Use case name View new incoming document Actor Employee, manager, administration department Purpose View new incoming document General description Click on document link and view document References R.4.3, R.5.6 Process description Action Response 1. Click on document link 2. Auto open the document Exception Connection error. Show error message. Uc12. Decide destination Use case name Decide destination Actor manager Purpose Choose destination General description Click on choose destination and choose which way document will be publish References R.4.4. Process description Action Response 1. Click on “Choose destination” button 2. Open form ask way to publish document Exception Connection error. Show error message. Uc13. Public document Use case name Public Actor Manager Purpose Public document to all employees General description Choose “public” check box References R.4.4.1 Process description Action Response 1. Choose “Public” check box 2. Ask to confirm 3. Choose “OK” to confirm 4. Show document on the web to all employees Exception Connection error. Show error message. Uc14. Forward to subordinates Use case name Forward to subordinates Actor Manager Purpose Forward to subordinates General description Choose subordinates to forward References R.4.4.2 Process description Action Response 1. Choose “Forward” checkbox and choose ordinates in the list then choose “Submit” 2. Show document on subordinate’s main panel Exception Connection error. Show error message. 3.4.5. New outgoing document processing package Figure 5. New outgoing document package Use case description: Uc15. Attach document Use case name Attach document Actor Employee Purpose Attach document to server General description Browse file and attach References R.5.1 Process description Action Response Browse document and click on “Attach” button Upload document to server Choose department or people to collect comments Show document in specific user’s panel Exception Connection error. Show error message. Require upload again Uc16. Collect comments Use case name Collect comments Actor Employee Purpose Get comments from others General description View comments of specific document in user’s panel References R.5.2. Process description Action Response Choose document and click on “View comments” Show comments on panel Exception Connection error. Show error message. Uc17. Edit document Use case name Edit document Actor Employee Purpose Edit and reattach document General description Choose document and reattach document References R.5.3 Process description Action Response Choose document and click on “Edit” button Show attach document form Attach document and choose “Submit” button Upload document to server Exception Connection error. Show error message. Require upload again Uc18. Send to administration department Use case name Send to administration department Actor Employee Purpose Send to administration department General description Choose send to administration department option References R.5.4 Process description Action Response Choose document and choose “Send to administration department” Show document in administration department’s panel Exception Connection error. Show error message. Uc19. Give comment Use case name Give comment Actor Employee Purpose Give comment for specific document General description Write comment and send to author References R.5.5 Process description Action Response Click on document and choose “Give comments” Show text area for writing comments Choose “Submit” Send comments to author Exception Connection error. Show error message. Uc20. View document Use case name View document Actor Employee, manager, administration department Purpose View document General description Click on document link and view document References R.4.3, R.5.6 Process description Action Response 1. Click on document link 2. Automatic download and open the document Exception Connection error. Show error message. Uc21. Send back to author Use case name Send back to author Actor administration department Purpose Send back to author General description Send back to author with comment References R.5.7 Process description Action Response 1. Click on document, choose “Send back” 2. Show Comment form Write comments and reasons for sending back. Choose submit Send back to author with comments Exception Connection error. Show error message. Uc22. Send to manager Use case name Send to manager Actor administration department Purpose Send document to manager General description Choose send to manager References R.5.7 Process description Action Response 1. Click on document and choose “Send to manager” 2. Show document on manager’s panel Exception Connection error. Show error message. Uc23. Set view right Use case name Set view right Actor Manager Purpose Set who could view the document General description Choose document and set view right References R.5.9 Process description Action Response 1. Click on document and choose “Set view right” 2. Show document only on user who have right Exception Connection error. Show error message. Uc24. Publish Use case name Publish Actor administration department Purpose Publish document General description Choose Publish option References R.5.10 Process description Action Response 1. Click on document and choose Publish button 2. Show choice option for document Exception Connection error. Show error message. Uc25. Public Use case name Public Actor administration department Purpose Public to all employee General description Choose public option References R.5.10.1 Process description Action Response 1. Choose public option 2. Show document on all user’s panel Exception Connection error. Show error message. Uc26. Register to “outgoing book” Use case name Register to “outgoing book” Actor administration department Purpose Register to “outgoing book” General description Write document information into “outgoing book” References R.5.10.2 Process description Action Response 1. Insert document’s information into form 2. Store information into database Exception Connection error. Show error message. Uc27. Send out Use case name Send out Actor administration department Purpose Send document out General description Choose email address and send out References R.5.10.3 Process description Action Response 1. Choose document and type email address 2. Send document via email Exception Connection error. Show error message. Uc28. Hide from web Use case name Hide from web Actor administration department Purpose Hide document from web in case document is old General description Choose document and choose hide from web References R.5.10.4 Process description Action Response 1. Choose document and choose “Hide from web” 2. Do not show document on panel Exception Connection error. Show error message. Uc29. Delete document Use case name Delete Actor administration department Purpose Delete document from database General description Choose document and choose “Delete” References R.5.10.5 Process description Action Response 1. Choose document and choose “Delete” button 2. Delete document from database Exception Connection error. Show error message. 3.4.6. Task processing package Figure 6. Task processing manager use case Figure 7. Task processing employee Uc30. Create request Use case name Create request Actor Manager Purpose Create request based on task General description Choose Create request and insert info References R.6.1 Process description Action Response 1. Choose “Create request” 2. Show Request information form Insert information. Choose “Submit” Store request into database Exception Connection error. Show error message. Uc31. Set due date (for whole task) Use case name Set due date for whole task Actor Manager Purpose Set due date for whole task General description Set date in due date form References R.6.2 Process description Action Response 1. Choose “Due date” 2. Show Due date option Choose date time Store date into database Exception Connection error. Show error message. Uc32. Attach documents Use case name Attach document Actor Manager Purpose Attach related document General description Browse documents and attach References R.6.3 Process description Action Response 1. Choose “Attach” and browse files to attach 2. Store files into database Exception Connection error. Show error message. Require reattach. Uc33. Divide task Use case name Divide task Actor Manager Purpose Divide task into steps General description Divide and name the step References R.6.4 Process description Action Response 1. Choose “Divide” and name each subtask 2. Store sub task into database Exception Connection error. Show error message. Uc34. Set condition Use case name Set condition Actor Manager Purpose Set condition for each subtask for synchronizing General description Set dependence for each subtask References R.6.4.1 Process description Action Response 1. Choose pretask 2. Store dependence into database Exception Connection error. Show error message. Uc35. Set priority Use case name Set priority Actor Manager Purpose Set order and priority for tasks General description Set order for tasks References R.6.4.2 Process description Action Response 1. Re arrange tasks in order 2. Store order into database Exception Connection error. Show error message. Uc36. Set due date ( for subtask) Use case name Set due date (for subtask) Actor Manager Purpose Set due date for subtask General description Choose due date for each subtask References R.6.4.3 Process description Action Response 1. Choose subtask and set date 2. Store date into database Exception Connection error. Show error message. Uc37. Set responsibility for subtask Use case name Set responsibility for subtask Actor Manager Purpose Set responsibility for subtask General description Choose subtask and set who is responsible for References R.6.4.4 Process description Action Response 1. Choose subtask, choose person responsible for 2. Store person into database Exception Connection error. Show error message. Uc38. Edit subtask Use case name Edit subtask Actor Manager Purpose Edit subtask General description Choose edit and change subtask information References R.6.4.5 Process description Action Response 1. Choose subtask, choose “Edit” 2. Show edit form 3. Edit subtask 4. Store into database Exception Connection error. Show error message. Uc39. Delete subtask Use case name Delete subtask Actor Manager Purpose Delete subtask General description Choose subtask and delete References R.6.4.6 Process description Action Response 1. Choose subtask and choose “Delete” 2. Delete from database Exception Connection error. Show error message. Uc40. Set responsibility for whole task Use case name Set responsibility for whole task Actor Manager Purpose Set responsibility for whole task General description Choose person who is responsible for whole task References R.6.5 Process description Action Response 1. Choose person to set responsibility 2. Store person into database Exception Connection error. Show error message. Uc41. Edit task Use case name Edit task Actor Manager Purpose Edit task General description Choose edit and change task information References R.6.6 Process description Action Response 1. Choose task, choose “Edit” 2. Show edit form 3. Edit task 4. Store into database Exception Connection error. Show error message. Uc42. Delete task Use case name Delete task Actor Manager Purpose Delete task General description Choose task and delete References R.6.7 Process description Action Response 1. Choose task and choose “Delete” 2. Delete from database Exception Connection error. Show error message. Uc43. View task status Use case name View task status Actor Manager Purpose View all task status to control how subordinates do subtask General description Choose “Task status” and view status References R.6.8 Process description Action Response 1. Choose “Task status” 2. Show all task status Exception Connection error. Show error message. Uc44. View task Use case name View task Actor Manager, Employee, Administration department Purpose View task General description Choose task and view content References R.6.9 Process description Action Response 1. Choose task and view content 2. Show content Exception Connection error. Show error message. Uc45. Give comments Use case name Give comments Actor Manager, Employee, Administration department Purpose Give comments for task General description Set dependence for each subtask References R.6.4.1 Process description Action Response 1. Choose pretask 2. Store dependence into database Exception Connection error. Show error message. Uc46. View due date Use case name View due date Actor Manager, Employee, Administration department Purpose View due date General description Choose subtask and delete References R.6. Process description Action Response 1. Choose subtask and choose “Delete” 2. Delete from database Exception Connection error. Show error message. Uc47. View related documents Use case name View related document Actor Manager, Employee, Administration department Purpose View related document General description Download and open related document References R.6.8.3 Process description Action Response 1. Click on related document 2. Show related document 3. Download related document 4. Download Exception Connection error. Show error message. Uc48. Read reminded task Use case name Read reminded task Actor Manager, Employee, Administration department Purpose Read reminded task General description Click on remind and read References R.6.9 Process description Action Response 1. Click on “reminded task” area 2. Show reminded task Exception Connection error. Show error message. Uc49. Provide suggestionssolutions Use case name Provide suggestionssolutions Actor Manager, Employee, Administration department Purpose Provide suggestionssolutions for tasks General description Type solutions in text area and send to others References R.6.10 Process description Action Response 1. Type solutions in text area 2. Show text area 3. Choose people to send to and choose “Send” 4. Send to people Exception Connection error. Show error message. Uc50. Confirm state of task Use case name Confirm state of task Actor Manager, Employee, Administration department Purpose Confirm task’s status ( finish, doing, not start..) General description Choose status checkbox References R.6.11 Process description Action Response 1. Choose task and choose status 2. Save status Exception Connection error. Show error message. Uc51. Attach produced documents Use case name Attach produced documents Actor Manager, Employee, Administration department Purpose Attach produced documents General description Browse files and attach References R.6.12 Process description Action Response 1. Browse files and attach 2. Upload to server Exception Connection error. Show error message. 3.4.7. View task schedule Figure 8. Task schedule Uc52. View task schedule Use case name View task schedule Actor Manager, Employee, Administration department Purpose View task schedule General description View task schedule References R.7 Process description Action Response 1. Choose “View task schedule” panel 2. Show panel Exception Connection error. Show error message. 3.5. Sequence diagrams 3.5.1. Login package Figure 9. Login sequence diagram 3.5.2. Logout package Figure 10. Logout package 3.5.3. User management package Figure 11. Use management sequence diagram 3.5.4. New incoming document package Figure 12. Incoming document administration department sequence diagram Figure 13. Incoming document manager sequence diagram Figure 14. Incoming document employee sequence diagram 3.5.5. New outgoing document package Figure 15. Outgoing document sequence diagram 3.5.6. Task processing package Figure 16. Task processing package 3.5.7. Schedule Figure 17. Schedule sequence diagram 3.6. Operation contract Op1. Login Name Login to system Responsibility Login successfully to access all function based on right level Reference Uc1 Exception Wrong username, password Output Main panel Precondition Account is created Postcondition Op2. Authentication check Name Authentication check Responsibility Check if username and password are valid Reference Uc2, Uc4 Exception Wrong username, password Output Error message Precondition Account is created Postcondition Op3. Logout Name Logout Responsibility Logout successfully Reference Uc3 Exception Connection error Output Logout successfully message Precondition User confirm to logout Postcondition Op4. Authentication check Name Authentication check Responsibility Check if username and password are valid Reference Uc2, Uc4 Exception Wrong username, password Output Error message Precondition Account is created Postcondition Op5. Create new user Name Create new user Responsibility Create new user profile in database Reference Uc5 Exception Not enough information or user already created Output Account created Precondition User have right to use this function Postcondition User created Op6. View user profile Name View user profile Responsibility Show all information about user Reference Uc6 Exception Connection error Output User’s Information Precondition Account is created Postcondition Op7. Edit user profile Name Edit user profile Responsibility Change user profile Reference Uc7 Exception Connection error Output Changed information Precondition Account is created Postcondition Op8. Delete user Name Delete user Responsibility Delete user from database Reference Uc8 Exception Connection error Output Delete message Precondition Account is created Postcondition User deleted Op9. Register into “incoming book” Name Register into “incoming book” Responsibility Store document information into “incoming book” Reference Uc9 Exception Not enough information. Connection error Output Result message Precondition Enough information Postcondition Op10. Store into database Name Store into database Responsibility Store document into database and server Reference Uc10 Exception Not enough information. Connection error Output Result message Precondition Enough information Postcondition Op11. View new incoming document Name View new incoming document Responsibility Show new incoming document Reference Uc11 Exception Connection error Output Show incoming document Precondition Document stored into database Postcondition Op12. Decide destination Name Decide destination Responsibility Update destination for document Reference Uc12 Exception Connection error Output Result message Precondition Document stored in database Postcondition Update successfully Op13. Public Name Public Responsibility All user could access the document Reference Uc13 Exception Connection error Output Result message Precondition Document stored in database Postcondition Update successfully Op14. Forward to subordinates Name Forward to subordinates Responsibility User who is chosen can view document Reference Uc14 Exception Connection error
Xem thêm

103 Đọc thêm

TÀI LIỆU MODULE 1 DISPLAYING DATA FROM A DATABASE DOCX

TÀI LIỆU MODULE 1 DISPLAYING DATA FROM A DATABASE DOCX

Demonstration: Tour of the Sample Web Site Fergusson and Bardell Inc. is a medium-sized IT solutions company based in New York. With an increase in the number of its employees, it is becoming difficult for the company to disseminate information, such as company policies, employee performance data, and personnel information and policies, to the employees. Also, the company is concerned about accidental disclosure of confidential information due to the amount of sensitive, paper-based documents in circulation. The company wants to create a centralized system for disseminating information to its employees. The Internal Communications department recommended that they create an intranet site that will be accessible only to the employees of the company. They also proposed that this should be a data-driven site that would allow employees to retrieve and update data, such as addresses and phone numbers. A decision was taken to create an intranet site for the company in which all company policies and employee information would be posted and from which the employees could access the information they need. During the course of this workshop, you will create an intranet site for Fergusson and Bardell. This demonstration takes you on a tour of a sample intranet site for a fictitious company called Fergusson and Bardell Inc. In this demonstration, you will focus on the PERSONNEL DATA link to retrieve detailed information for an employee. The PERSONNEL DATA link connects you to the PERSONNEL DATA page, which shows the information for each employee in the database results page. A hyperlink is created on the database results page, which links to the detail results page. The detail results page displays the information for a
Xem thêm

40 Đọc thêm

TÀI LIỆU CHAPTER 2: ABAP QUERY PDF

TÀI LIỆU CHAPTER 2: ABAP QUERY PDF

also specify functional groups in the selected functional area. This means the selected area (and the groups) must contain all the fields you wish to include in the query. Using queries If appropriate authorizations are in place, you can execute, modify, copy, and delete queries. Any modifications to queries affect all users of a user group. That is, if one user deletes a query, it is lost for all other users as well. All changes or new creations are at once visible to all users. Starting with Release 4.0, queries can have 12-character names. Prior releases were limited to two-character names. Queries have three different types of reports or lists: < Basic list: Sorts and totals selected fields as specified by the user in the query. This is the most common kind of report. < Statistical list: Totals, calculates averages, and allocates percentages based on the fields in the query. < Ranked list: Ranks fields based on numeric fields, including currency or quantity. A single query may have multiple statistical and ranked lists but only one basic list. Chapter 2: ABAP Query Learning the Basics of ABAP Query Report Development Tools 2–5 Related Terminology < Logical database: A series of tables that are linked together via a logical database program. < Functional groups: Part of a functional area. You create functional groups within a
Xem thêm

34 Đọc thêm

đáp án bài tập hệ quản trị cơ sở dữ liệu SQL

ĐÁP ÁN BÀI TẬP HỆ QUẢN TRỊ CƠ SỞ DỮ LIỆU SQL

Bài 1 Quản lý bán hàng
create database Bai1
create table dmkhach
(mak char(20) primary key,
tenk char(20),
diachi char(20),
dienthoai char(15))

create table dmhang
(mah char(20) primary key,
tenhang char(20) ,
dvt char(30),
soluong int )

create table hoadonban
(sohd char(20) primary key,
mak char(20),
ngayhd datetime,
diengiai char(30),
constraint mak foreign key (mak)references dmkhach(mak))

36 Đọc thêm

BÀI TẬP LÀM QUEN VỚI HỆ QUẢN TRỊ CƠ SỞ DỮ LIỆU INFORMIX

BÀI TẬP LÀM QUEN VỚI HỆ QUẢN TRỊ CƠ SỞ DỮ LIỆU INFORMIX

Module ‘Index’ Exercises1. Copy and paste the following SQL statements to a file called fill.sql:2. Run the script and measure the time that is used for execution:time dbaccess stores_demo fill.sqlWrite down the resulting time.3. Edit the SQL script and change the line4. Create an SQL script access.sql that contains the following statementselect * from big where id=1000000Bounce the database server, run the script and measure the time that is used forexecution. Write down the execution time.5. Open dbaccess and navigate in the menu to Query-Language->Info. Choose thetable big. Go to the Constraints->Primary menu and write down the name of theprimary key constraint. Go to Query Language and execute following statementalter table big drop constraint 6. Bounce the database server, run the script access.sql again and measure the timethat is used for execution. Write down the execution time. Compare it with result from 4.and explain the difference.Does it make sense if the DBMS uses the index in the following query?select sum(number)from bigwhere mod(id,2)=0Explain!
Xem thêm

63 Đọc thêm

33989 MAKING AN ADVERTISEMENT

33989 MAKING AN ADVERTISEMENT

http://www.apple.com/itunes/**NEW PRODUCTS by APPLE**Click on the blue link to choose a product to advertise.1. Read about the product2. Write the features (qualities) that are amazing about it!!3. Create an Article that advertises the product4. Write at least 5 facts about the new product(Draw an image or print one) This project HAS TO include:1) PRODUCT NAME2) PRICE3) 2-4 Features / Product information from website( ie. 4 MP Camera, 6 GB memory, details about product )4) An opinionWOW!WHAT AN AMAZING DEAL!THEY’RE SELLING FAST!

1 Đọc thêm

PRO review of VasQ Videopress and Special 10,000 Bonus pack

PRO REVIEW OF VASQ VIDEOPRESS AND SPECIAL 10,000 BONUS PACK

This new software is a real game changer, you can create stunning video website and cash in on the video buzzing trend… WITHOUT ever creating a single video
You dont need to have a single video
You dont need to act in front of camera
You dont need to produce videos
No programming skills needed
Dont just take my words, click the link below to see it yourself:
This revolutionary software is called VasQ Videopress

15 Đọc thêm

Chuyên đề : Giao thức OSPF

CHUYÊN ĐỀ : GIAO THỨC OSPF

Giao thức định tuyến OSPF( open shortest path first)hoạt động dựa trên kỹ thuật trạng thái liên kết Các bộ định tuyến OSPF duy trì bức tranh chung về mạng và trao đổi thông tin liên kết lúc khám phá ban đầu hay khi có thay đổi về mạng Kỹ thuật LinkState không gửi bảng định tuyến mà gửi bảng cơ sở dữ liệu trạng thái đường link LSDB( link state database )Giải thuật được sử dụng là Dijktra

18 Đọc thêm

ArcView practices practice 4 working with tables

ARCVIEW PRACTICES PRACTICE 4 WORKING WITH TABLES

This practice extends your knowledge ofhow GIS is used to find new information based on existing data. Perhaps the defining feature of a geographical information system is the ability to analyse data in a spatial context. Other software can handle attribute or even geographical data, however a GIS can take these data and increase your knowledge about the place. This practice covers a few ofthe kinds of analysis that GIS software can do.
In this practice, you will be able to: • Relate (join) nonspatial database table to a geographicalbased table (spatial join) • Create buffers for geographic features (buffering) • Discover the ability to select the features of one or more themes using the features of another theme (spatial relationship) Firstly, you will need to start ArcView, start a new project, add a view and set the working
directory (to c: emp or c:) as practiced last week. Secondly, you need to open a View using the view icon in the project window in ArcView. Thirdly, you need to add some themes, cities.shp, mjrivers.shp, mjurban.shp and country.shp from the directory, c:arcv32arcviewesridataeurope. This is the same process what you had done in the first practice session. These themes will now be added to your view
Xem thêm

8 Đọc thêm

CHAPTER 6: SQL (STRUCTURED QUERY LANGUAGE)

CHAPTER 6: SQL (STRUCTURED QUERY LANGUAGE)

Chapter 6: SQL (Structured Query Language)
Contents
1 The COMPANY Database
2 SQL developments: an overview
3 DDL: Create, Alter, Drop
4 DML: select, insert, update, delete
5 DCL: commit, rollback, grant, revoke

107 Đọc thêm

BACKUP ORACLE BE 11D

BACKUP ORACLE BE 11D

Phần mềm Backup ExecHướng dẫn Backup/RestoreOracle Database với BE 11d1.1.Cấu hình BE Remote AgentCấu hình BE Remote AgentTrước khi tiến hành backup Oracle Database ta cần cấu hình Remote Agent của phần mềmBackup Exec trên máy chủ chạy cơ sở dữ liệu Oracle.1.1. Yêu cầu 1. License Backup Exec for Oracle2. Tạo một Oracle user cho Backup Exec Oracle Agent.Sử dụng SQL Plus tạo một user (ví dụ: user=backup/password=backup):SQL> create user backup identified by backup;Gán các quyền tương ứng cho user này:SQL> grant unlimited tablespace to backup;SQL> grant AQ_ADMINISTRATOR_ROLE to backup;SQL> grant sysdba to backup;SQL> alter user backup default role all;SQL> alter user backup default tablespace system;Kiểm tra xem user đã được gán các quyền tương ứng hay chưa:SQL> connect backup/backupSQL> select GRANTEE, PRIVILEGE from DBA_SYS_PRIVS where GRANTEE=’BACKUP’ union select GRANTEE, GRANTED_ROLE from DBA_ROLE_PRIVS where ‘GRANTEE’=’BACKUP’Các quyền sau sẽ được hiển thị:AQ_ADMINISTRATOR_ROLESYSDBAUNLIMITED TABLESPACETa có thể sử dụng user sys của Oracle để thực hiện các tác vụ backup/restore.3. Đặt Database ở chế độ archive log.
Xem thêm

14 Đọc thêm

TÀI LIỆU HỌC LẬP TRÌNH PHP VÀ MYSQL CƠ BẢN TỪ A ĐẾN Z

TÀI LIỆU HỌC LẬP TRÌNH PHP VÀ MYSQL CƠ BẢN TỪ A ĐẾN Z

+ Vùng làm việc của mình sẽ nằm ở C:\xampp\htdocs .Đây sẽ là nơi lưu trữ code+ Bây giờ bạn thử copy một tập tin nào đó vào trong thư mục C:\xampp\htdocs rồichạy tên miền http://localhost, bạn sẽ thấy nó liệt kê file mà bạn vừa copy vào.+ Nếu bạn click vào file ảnh đó thì trình duyệt sẽ hiển thị ảnh với đường dẫnlà http://localhost/tên-tập-tin. Đây được xem là một link ảnh trong website của bạn.+ Tương tự, hãy thử tạo một thư mục bất kỳ rồi copy một tập tin nào đó vào, thì bâygiờ bạn có thể truy cập xem ảnh với đường dẫn là http://localhost/tên-folder/tên-tậptin.Như vậy bạn có thể hiểu, cái đường dẫn trên website nó sẽ phân thứ cấp tùy theo cấutrúc thư mục và file trong đó.1.1.5.2 Tạo cơ sở dữ liệu MySQL (Database)- Khi nhắc đến database, bạn phải nhớ là nó bao gồm các thành phần chính là:+ Tên user của database.+ Mật khẩu của user database.+ Tên database.+ Database Host (thường thì điền là localhost, bất kể là bạn dùng ở localhost hay hostbình thường).HD: Trịnh Thanh TâmEmail: contact.tamsoft@gmail.comPage 7Khóa lập trình PHP Onlile- Bạn hãy tưởng tượng rằng, user của database sẽ có nhiệm vụ đọc và ghi dữ liệu vàodatabase nên khi sử dụng các mã nguồn PHP, bạn phải khai báo cùng lúc cả user củadatabase và tên database.- Đối với localhost, bạn không cần tạo user cho database mà sẽ sử dụng thông tin usernhư sau:
Xem thêm

112 Đọc thêm

SQL sever 2008 create new database

SQL SEVER 2008 CREATE NEW DATABASE

SQL (structured query language) là ngôn ngữ dùng để truy vấn các dữ liệu có cấu trúc. SQL được hỗ trợ ở hầu hết các hệ thống quản lý cơ sở dữ liệu như MS Access, SQL server, MySQL, Postgres, …Các câu lệnh trong SQL được phân chia thành 3 loại chính:Data DefinitionData ManipulationData ControlCác lệnh cơ bảnData Definition1.Lệnh Create Table:Câu lệnh Create Table dùng để tạo bảng dữ liệu.Cấu trúc chính của lệnh Create TableCreate Table table_name(column_name1 data_type(size) attributes,column_name2 data_type(size) attributes,column_name3 data_type(size) attributes,…
Xem thêm

7 Đọc thêm

PHP MySQL TÀI LIỆU PHP

PHP MYSQL TÀI LIỆU PHP

Tạo kết nối đến database serverLựa chọn CSDLXây dựng truy vấn và thực hiện truy vấnXử lý kết quả trả vềĐóng kết nối đến serverHàm trả về mã số nhận dạng (link_identifier) nếu kết nối nếu thành công, ngược lại trả về FALSE cùng thông tin lỗi nếu kết nối thất bại. Có thể thêm kí tự trước tên hàm nếu không muốn hiện thị thông báo lỗi.

21 Đọc thêm

AMERICAN TNCs: BROKEN PROMISE OF FREEDOM AND EQUALITY OF OPPORTUNITY

AMERICAN TNCS: BROKEN PROMISE OF FREEDOM AND EQUALITY OF OPPORTUNITY

As economic development has become the leading objective of each nation in the world, human care has been gradually faded in order to fulfill that goal. The existence and growth of transnational corporations (TNCs), especially American TNCs has further highlighted that tendency while the USA is often described as destination for freedom and equality. Therefore, this research investigates American TNCs’ respect for freedom and equal opportunity in terms of their labor treatments and expansion strategies when they operate their affiliates abroad.
Secondary approach with documentary and contextual analysis of observed phenomenon and case study are intensively used to study about American TNCs’ activities, the coordination between their operation and code of conduct in business through detailed contexts.
Results of the study prove the link between the expansions of crossborder capitalism and broken promise for better practice of worker and human rights. In particular, burgeoning penetration of American TNCs has threatened host countries’ territorial sovereignty. Furthermore, under the pressure of cutting cost, American TNCs have exploited cheap labor force, and have implemented irrelevant wage levels, poor employees’ benefits and have offered inadequate training and promotion. They also create unequal competition in the interaction with local firms to maintain their monopoly.
Xem thêm

63 Đọc thêm

CHAPTER 6 TRIGGER STORE PROCEDURE FUNCTION CURSOR IN ORACLE

CHAPTER 6 TRIGGER STORE PROCEDURE FUNCTION CURSOR IN ORACLE

Contents
1 Trigger
2 Store Procedure Function
3 Cursor Trigger Overview
A trigger is a procedure which is executed implicitly whenever the triggering event happens.
Executing a trigger is to “fire” the trigger.
Triggering Events are:
DML Commands: INSERT, UPDATE, DELETE
DDL Commands : CREATE, ALTER, DROP
Database Events: SERVERERROR, LOGON, LOGOFF, STARTUP, SHUTDOWN

39 Đọc thêm

Báo cáo môn Hệ quản trị cơ sở dữ liệu oracle, đề tài quản lý khách sạn trên oracle

BÁO CÁO MÔN HỆ QUẢN TRỊ CƠ SỞ DỮ LIỆU ORACLE, ĐỀ TÀI QUẢN LÝ KHÁCH SẠN TRÊN ORACLE

MỤC LỤC
LỜI CẢM ƠN 2
MỤC LỤC 3
NỘI DUNG THỰC HIỆN 5
1. Database diagram: 5
2. Contsraints (Ràng buộc) 6
2.1. Ràng buộc trên bảng KhachHang: 6
2.2. Ràng buộc trên bảng Phong: 6
2.3. Ràng buộc trên bảng PhieuThuePhong: 6
3. Triggers 6
3.1. Trigger trên bảng HoaDon 6
4. Stored procedures 8
4.1. Thêm khách hàng mới 8
4.2. Cập nhập thông tin khách hàng 8
4.3. Thêm phòng mới: 9
4.4. Cập nhập thông tin phòng: 9
4.5. Xoá thông tin phòng: 10
4.6. Thêm loại phòng: 10
4.7. Cập nhập loại phòng: 11
4.8. Xoá loại phòng: 11
4.9. Thêm phiếu thuê phòng: 12
4.10. Thêm chi tiết thuê phòng 12
4.11. Thêm sử dụng dịch vụ: 13
4.12. Xoá sử dụng dịch vụ: 13
4.13. Xác nhận trả phòng: 14
4.14. Thêm dịch vụ mới: 15
4.15. Cập nhật thông tin dịch vụ: 16
4.16. Xoá dịch vụ 16
4.17. Thống kê 17
5. Create Function 18
6. Create Transaction 19
7. Create View 20
7.1. View chi tiết thuê phòng 20
7.2. View chi tiết dịch vụ phòng 20
8. Create index 21
9. Phân quyền user: 22
10. Kết nối hai máy 23
Xem thêm

22 Đọc thêm

TÀI LIỆU PASSWORD FILE AUTHENTICATION DOC

TÀI LIỆU PASSWORD FILE AUTHENTICATION DOC

Using Password File Authentication This section describes how to authenticate an administrative user using password file authentication. See Also: SQL*Plus User’s Guide and Reference for syntax of the CONNECT command Operating System Group UNIX Windows OSDBA dba ORA_DBA OSOPER oper ORA_OPER See Also: Your operating system specific Oracle documentation for information about creating the OSDBA and OSOPER groups Database Administrator Authentication The Oracle Database Administrator 1-19 Preparing to Use Password File Authentication To enable authentication of an administrative user using password file authentication you must do the following: 1. Create an operating system account for the user. 2. If not already created, Create the password file using the ORAPWD utility: ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users 3. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE. 4. Connect to the database as user SYS (or as another user with the administrative privilege). 5. If the user does not already exist in the database, create the user. Grant the SYSDBA or SYSOPER system privilege to the user:
Xem thêm

5 Đọc thêm

geological database draft

GEOLOGICAL DATABASE DRAFT

OBJECTIVES
• To become familiar with Surpac’s Geological Database module.
• To learn about the minimum requirements for a geological database.
• To learn to import data into a database from ASCII text files.
• To learn to map a database
• To create composite files
• To view data and create sections
Using these principles then to apply to interpreting geological sections

101 Đọc thêm