I used the Oracle database for the first time. I used SQL Server 2005 in the past. Some questions and feelings are as follows:
1. Oracle client Installation
First, the Oracle client is installed to access the Oracle database in the company's LAN.
On Thursday, this week, PL/SQL compiled in OracleCodeMigration to PostgreSQL plpgsql.
When I started to talk about the problem, the database ipvs probably felt rough after a week. Summary of the reasons: 1. In the past three years, apart from
1. Variable assignment
Create or replace procedure pro_testis type v_a_count is record (a number, B varchar2 (50); v_a_countinfo v_a_count; --------- this requires attention to beginselect A, B into v_a_countinfo from a_count;
-- Delete a table --Drop Table account;
-- Student information table --Create Table student (Stu_id number (10) Not null,Stu_name varchar2 (20) not null,Stu_sex char (5) not null,Stu_birthday date not null,Constraint pk_student primary key (stu_id)
1. Processing of null in orderBy default, Oracle considers null as the maximum value in order by. Therefore, if it is ASC, it is placed at the end of the ascending order, and desc is placed at the top of the descending order.Of course, you can also
Some people said that they would first delete a user and then create the user.
I want to delete all tables under this user, but do not delete others.
1. query all tables under this user:
Executed under this user (no result, because it should not
Oracle temporary tablespace is mainly used to query and store some buffer data. Temporary tablespace consumption is mainly caused by sorting the intermediate query results. Restarting the database can release temporary tablespace. If the instance
/*View the definition of the salary field in the structure of the HR. Employees table:Desc HR. employees;Press Ctrl + to click*/
/*The variables v_salary_num, v_salary_type, and v_salary_subtype are defined by number, % type, and sub-type
The following SQL statement in PL/SQL:
Select---- The root cause is clearly marked once, and every 4 RMB is a group of resources;Trunc (D. ITEM_ID-1)/1) + 1,-- Issue invoice, dateA. invoice_no,A. invoice_date,-- Keep others, keep RateA. currency,A.
The following functions must be implemented when creating an external table:
The main invoice Table A has a customer named login Login A. IdentityThere is another table in Table B. There may be many partition methods for the same partition, or there
Create and manage multiple database instances in Oracle1007 people read comments (0) collect reports
1. After the database assist or create database statement is used, the system prompts that the database already exists.
2. Create with database
Create Table wzw_sales(Acct_no number (5 ),Person varchar2 (30 ),Sales_amount number (8 ),Week_no number (2))Partition by range (week_no)Subpartition by list (acct_no)(Partition part9 values less than (9)Tablespace dw_cdr_dataPctfree 10Pctused
------ Spool settingsCommon spool settingsSet colsep ''; // The output delimiter of the domain.Set echo off; // display each SQL command in the Start script. The default value is onSet feedback off; // display the number of records processed by this
Address: http://tech.sina.com.cn/s/2008-09-05/0907794823.shtml
The greatest difference between an SQL Server database and an Oracle database is the tablespace design. Oracle Database pioneered the design concept of tablespace, which makes an
CREATE DATABASE LINK
-- Create a link (created in the target database) Create [public] database link linknameconnect to username identified by passwordusing 'connectstring '; -- create public database link database connection name connect to user
Yan Bin (write to me)Original blog (http://blog.csdn.net/binbinxyz), reprint please indicate the source!
Assume that a five-digit number is obtained from the database as the serial number of the business on the current day (unique on the current
In the past few days, using kettle to capture data involves a lot of processing time. Let's take a look at two figures:
Kettle is used to capture data without having to obtain the time. For Oracle databases, there are many time-specific functions.
Function calls in other languages
Java function call
Create a Java resource in the Oracle database, or use the loadjava command to load other Java classes or jar
Create or replace and compile Java sourcenamed mytestjavaPublic class factorial
Functions in the database include the following four parts:
Declaration, return value, function body, and Exception Handling.
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->1 create or replace
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