1. Display user Information
(1) Display the current session user
10:16:18 sql> Show user;
USER is "SYS"
(2) Show privileged users
10:17:07 sql> Conn sys/oracle as SYSDBA;
Connected.
10:17:09 sql> SELECT * from V$pwfile_users;
USERNAME Sysdb
Create or Replace package p_page is
--Author:pharaohs
--Created:2006-4-30 14:14:14
--Purpose: Paging process
TYPE Type_cur is REF CURSOR; --Define a cursor variable to return the recordset
PROCEDURE Pagination (
Pindex in number--Paging index
When sorting, grouping, and indexing are done in an Oracle database, a lot of temporary data is generated. If you have a table of employee information, the database is the time to set up records to save. If a user queries by using the ORDER by sort
First download from the Internet:
[oracle@jumper]$ wget http://www.realvnc.com/dist/vnc-4.0-x86_linux.tar.gz --10:34:32-- http://www.realvnc.com/dist/vnc-4.0-x86_linux.tar.gz => `vnc-4.0-x86_linux.tar.gz' Resolving www.realvnc.com... done.
The following is a detailed analysis of the three methods of the new Oracle database, the need for friends can come to reference the next
1. Create, configure, or delete databases by running Oracle database Configuration Assistant (You can also
Ora-01650:unable to extend rollback segment name by NUM intablespace name
Cause: The Oracle error described above is caused by an insufficient number of tablespaces in the rollback segment, which is also the most common Oracle error message for
oracle| stored procedures from the beginning of learning PHP to Joy International village, for several months, learned a lot of things, I wrote an example hope a bit useful.
The PHP program accesses the database and can use the stored procedure
oracle| Design | data | Repeat we may have this situation, a table originally poorly designed, resulting in the table data data duplication, then, how to delete the duplicate data?
Duplicate data may have two scenarios, the first one being only
Enterprise|oracle
1) Hardware Environment
At least 512MB RAM, but 256MB due to test enough
Hard drive must be at least 6G (2G system +4g database)
2) Installation RHEL3ASU2
Choose the minimum installation, about 500 MB.
Turn off the firewall.
Fixed
Oracle
Oracle Common fool question 1000 Q (12)
Author: ccbzzp
9I managed data dictionary all view.
783. All_all_tables
All tables accessible to the user.
784. all_arguments
All the parameters of the object that the user can access.
785.
oracle| Error | solution | original
No one will deny that Oracle is one of the world's most influential database products, but that good things don't always seem to be as useful (at first glance), or even ruthless--always give layman a ruthless
Oracle
Result Sets from Stored procedures in Oracle
A Frequently asked question is:
I ' d like to know whether ORACLE supports procedures (functions) which
Returns result sets.
The answer is most definitely yes. In short, it ' ll look like this:
oracle| problem
ORACLE interview Questions-Technical articles (2)
21. How to determine the time zone of the database?
Answer: SELECT dbtimezone from DUAL;
22. Explain the purpose of global_names set to True
Answer: Global_names indicates how the
Database concurrent access, where two or more users access the same data at the same time, is the biggest problem for the database engine to design and implement a moderate response. A well-designed, performance-capable database engine can easily
Common functions: Substr and InStr1.SUBSTR (String,start_position,[length]) to substring, return stringExplanation: String meta stringsStart_position start position (starting from 0)Length optional, number of substringssubstr ("ABCDEFG", 0);
This blog record in a one-time testing process, the location of high CPU utilization bottleneck problem, the main location of SQL is subject to One, sql command positioning 1. first with top command monitoring system resources, if aix
I. OverviewSome time ago, there was a DBA friend after the Rebuild table (rename) work, the next morning the business is not working properly, the data can not be inserted restrictions and errors, later analysis found that the cause of the error is
Oracle Service Scanning Tool Oscanner Oracle is a relational database launched by Oracle for large-scale data storage such as large enterprises, telecommunications, banking and other industries. Kali Linux integrates the Oracle Service Scan
--Create a User Yong2,yong2 table space for users, a temporary tablespace of temp,users tablespace size of 10M, the password immediately expires, the user locked.CREATE USER Yong2Identified by QwerDEFAULT tablespace UsersTemporary Tablespace
Oracle manages the storage space in a database data file (datafile) as a data block. A data block is the smallest (logical) unit of data in a database. Corresponding to the data block, the smallest physical storage unit of all data at the operating
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service