Oracle

1. query the number of connections to the current process of the database:Select count (*) from V $ process;2. view the number of connections in the current session of the database:Elect count (*) from V $ session; 3. view the number of concurrent

Recently, you need to perform some stored procedure tests. You can only test the stored procedure in your local database instance. The results show that an error occurred while logging on to the previously created database instance. The error

This is a few questions about the database recently encountered during the interview process. I feel very good, and I often encounter these questions in projects. Question 1: There are three user tables (users), role tables (role), and user role

Recently, the Entity Framework 4.1 and LINQ frameworks were used for development. However, the primary key values in the Oracle data table use sequence generation auto-increment values, when adding a record, you must query and obtain the Sequence

Generally, if you installOracleServerSoftwareOracle ODBC source is automatically added, so you do not need to do anything. Now I will explain how to add Oracle ODBC source through the Oracle client. Step 1, click this link

How to use ORACLE sequence: An Oracle sequence is a database item that can generate an integer sequence. It is usually used to fill in a numeric primary key column. 1. Create sequence: Create sequence sequence_name [Start with start_num]

  Example: (1) query data in the users table. Select U. ID, U. realname, U. Sex from users U; The query result is as follows: Id realname sex1 10082 pine xx2 10084 Lin XX 13 10087 West xx4 10100 Hu xx5 10102 dragon XX 1......

Recently, because SuSE Linux was used for server deployment and is not familiar with it, we found that the table box field annotations of the Database become garbled after Oracle deployment, after the system character set and Oracle character set

OracleCondition branch usage A. If... then B. If... then... Else C. If... then... elsif .... Else Instance1 Question: When writing a process, you can enter an employee name if the employee's salary is lower2000To increase the

Case: The salesperson's salary in the Scott. EMP table can only increase, but cannot decrease Code: Create or replace trigger tr_emp_updBeforeUpdate of SalOn EMPFor each row -- Triggered only when the salesperson is updated When (Old.

InProgramWhen defining variables, constants, and parameters, you must specify the PL/SQL data type for them. When compiling PL/SQL programs, you can use the scalar type, composite type, reference type, and lob (largeObject. The most common

I have been using MySQL and Oracle databases for so many years. This time I have to use the C/C ++ language to call the Oracle stored procedure, so I am too lazy to look at the OCI API, I went online to find someone else's encapsulated library, and

In large-scale project development, common databases are Oracle databases. However, an Oracle client requires a large disk. After installation, two functions are basically used: TNS Configuration Service name and sqlplus. During development, toad

I. Overview: Exp and IMP tools are logical Import and Export tools provided by Oracle all the time --- original!   Ii. Basic usage Exp user/password @ TNS [full | Owner | tables | tablespaces | transport_tablespace] file = rows = IMP

Oracle --> MySQL To_char (sysdate, 'yyyy-mm-dd') --> date_format (sysdate (), '% Y-% m-% D ');To_date (sysdate, 'yyyy-mm-dd') --> str_to_date (sysdate (), '% Y-% m-% D '); 1. Oracle (1) Use the to_char function to process numbers To_char

At work, we need to install Oracle10g and 11g in suse10. I have found a lot of information, but the content is not consistent. I want to help more people and leave it to myself, poor memory. Simply record the operation process.   1. Check

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or

The most basic task of a database is to store and manage data. The only database feature that an end user can see is its performance: the speed at which the database processes the results of a specified query, and return the result to the tools and

1. Create a table named test first. Create   Table Test   ( Index Number (9, 0) Not   Null , Name Varchar2 ( 128 ), Address Varchar2 ( 128 ), Primary   Key (Index) ) Tablespace Temp ; 2. Create sequence test_seq

After modifying a stored procedure and checking whether the modified stored procedure is correct, the stored procedure is debugged, after debugging, the system finds that a record is missing from the result set. After searching, it finds that the