18. Create and use a view tableView tableView table conceptsCreate a viewModify and delete a tableEnhanced viewing table functionality in SQL Server 2000SummaryIn Chapter 17th, we learned about indexes. indexes are a secondary database structure
Groups viewing the members of the currently logged on user groupGroups Gliethttp View the group that the Gliethttp user is in, and the members in the groupWHOAMI View the currently logged in user name/etc/group file contains all groupsAll user names
Groups viewing the members of the currently logged on user groupGroups Gliethttp View the group that the Gliethttp user is in, and the members in the groupWHOAMI View the currently logged in user name/etc/group file contains all groupsAll user names
Role of database view
09:36:42 | category:Sybase | font size subscription
I wrote my understanding of the view into this post and discussed it with everyone. A view has the following functions:
1. Simplify applications.
As an entity in the database,
1. When you modify, query, or delete a record, the system will prompt how many records are affected, but no table creation prompt will be displayed. When the table data is modified, it is reflected in the view. The command for modifying, querying,
Oracle Database full recovery and Incomplete recovery, and perform user management for multiple generations recovery, oracle user management
Comparison between full recovery and Incomplete recovery:
1. Full recovery: restores the database to the
Log in to the database using the DNINMSV31 account to do the following:1) Create User:CREATE USER NORTHBOUND identified by NORTHBOUNDDEFAULT tablespace "Tbs_dninmsv31"Temporary tablespace "TEMP2"QUOTA UNLIMITED on "tbs_dninmsv31";( Note: Quota is to
PrefaceThis article is mainly a supplement to the previous article, we introduced the SQL Server service startup process encountered some problems and solutions, you can click to view, we mainly describe the SQL Server startup process about the user
-- Reprinted in notes of Zhou chaoyong of the project team
Subject:1. Configure table space and various user objects.2. Create a data image from a real-time database to a backup database.
Environment: Sun Solaris UNIX 9Oracle 9i
Condition: 1. Two
Oracle is a database management system, which is a relational database management system. Usually we call the "database", contains the physical data, database management system, memory, operating system of the composition of the process, refers to
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.