Create a test tableCreate Table test_img ( ID integerprimarykey, name VARCHAR2(+), image blob);Storing picturesImportJava.io.FileInputStream;Importjava.io.FileNotFoundException;Importjava.io.IOException;ImportJava.io.InputStream;ImportJava.
Vempno Emp.empno%type;For example, the above sentence,Your vempno is the variable that you define, and the EMP that is in your database is the table that exists inside of it, his table is intentionally a empno field, and then%type is the data type
1, query Oracle version, database SID select * from V$version; Select name from V$database;2. Query the features supported by the Oracle database SELECT * FROM V$option;3. Get the database character set SELECT * from Nls_database_parameters; SELECT *
Data dictionary1, the Dynamic Data dictionary is a data dictionary starting with v$xxx, about 150 in the database, these data dictionaries reflect the dynamic state of the database, at different times the query will get different results.2. DBA data
Create user syntax:Create user usernameidentified by password;Em:create User WANGWCidentified by Tiger;To modify the user password syntax:Alter user usernameidentified by password;Em:Alter user WANGWCidentified by Rezin;Delete User syntax:Drop user
The statistics of the global temporary table cannot be collected, if it is collected, its statistic is definitely 0, it will cause the execution plan is not allowed, so we should lock up its statistic information and prevent the system from
Collection Key Words:1 , UNION: Set, all contents are queried, repeated display once , Sort Ascending By default ;2 , UnionAll: The collection, all the content is displayed, including the duplicate , there is no sort of display content ;3 ,
[Oracle] Get the data analysis you want from a string resourceRequirements: Order analysis, according to the game, account level, game account occupation, district clothing, price range analysis of the transaction data movement。Target: Order
Oracle set feedback
1. set feedback on
Oracle will give feedback when an SQL statement is sent by default.For example, execute the following table creation statement:
Create table t_test_lll (id varchar2 (10 ));
The command line returns Table
ORACLE File deleted by mistake
Today, a colleague found me and said that his database could not be used. I hope I can help with the research.
In fact, I do not have any in-depth research on the database, but I like to take a look at the online
Oracle simple column-to-row
The requirement is to count the total salaries of different jobs in each department.
SQL> select deptno, ename, job, sal from emp; deptno ename job sal ---------- -------- --------- ---------- 20 smith clerk 80030 allen
The Oracle11g system automatically collects statistics.--- 11 GB is from Monday to Friday-Saturday-SELECT w. window_name, w. repeat_interval, w. duration, w. enabledFROM dba_autotask_window_clients c, dba_scheduler_windows wWHERE c. window_name = w.
Index usage mode
For some large SQL statements, most tuning scenarios have the feeling of being cool-fed. If the data is screened by millions or tens of millions, full table scan is an extremely resource-consuming process. However, if an index scan
Oracle Database Connection
Modeled http://blog.csdn.net/makenothing/article/details/17080069
1. Create an Oracle connection. Add a database connection in VS2010.
Obtain the connection string
Data Source = server1; Persist Security Info = True; User
Oracle-function exercise
/** Scm_iss.test_imti_fun2 * Function with input parameters */create or replace function TEST_IMTI_FUN2 (P_NO in number) RETURN VARCHAR2 IS P_IMTI_NAME VARCHAR2 (200); P_IMTI_DESC VARCHAR2 (200 ); p_RETURN VARCHAR2 (200);
YourSQLDba sets the shared path backup and yoursqldba path backup
YourSQLDba can back up a database to a network path (shared path). This feature is also very flexible and has never been used before. Due to a recent requirement, so I tested
ORACLEprofile limit maid 4 -- CREATEPROFILE
Â Â Æ ª ² Í Ê çoracle profile Ï µá Ð µäzúä ä£ £%öö %%%%%%µ%» â  £%%%%%%%%%%%%%%%%%%%%%%%%%%% comment ''¨ profile ° Í Ê Ó Ã profile ø Ø Ð × Ê Ô'' ° Í Ü Â ë ø öööCREATE PROFILE
Note:Oracle recommends that
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