Oracle initial experience

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.

Migration from Oracle PL/SQL to Postgres plpgsql

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

% Rowtype in Oracle

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;

Oracle Learning (2)

-- 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)

Order by in Oracle

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

Oracle backs up and deletes a backup from the past

@ Echo off ECHO is backing up database files. Please wait ...... Exp.exe report/OK @ report file = D:/reportback/Report % date %. dmp log = D:/reportback/Report % Date :~ 0, 10%. Log   ECHO is deleting the backup file. Please wait ......

Oracle deletes all tables of a user.

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

Role of temporary Oracle tablespace

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

Oracle Learning (5)

  /*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

Ifs + Oracle Attention attention should be paid to the shard;

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.

Special External Store practices for Oracle-out-of-band connections.

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

Oracle multi-instance

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

Oracle composite partitioning

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

Oracle exports data to excel, CSV, txt, html

------ 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

Oracle tablespace Design Concept

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

Oracle tablespace creation and users

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

Oracle stored procedure and Timer

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

Oracle query Time Functions

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.

Oracle calls Java

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

Oracle functions and triggers

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

Total Pages: 2147 1 .... 2101 2102 2103 2104 2105 .... 2147 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.