`
tanglei198577
  • 浏览: 59681 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
社区版块
存档分类
文章列表
All these codes test on oracle9.2.First,give the all the base tables and datas for learning pl/sql.They will be all used in the following testing. create sequence student_sequence start with 10000 increment by 1; create sequence room_sequence start with 20000 increment by 1; create table ...

Oracle functions

Examples of function in oracle 9i,pls check the defination of them if not clear about it. 1.select ascii('A') A,ascii('a') a,ascii(0) zero,ascii(' ') space from dual 65 97 48 32 2.select chr(54740) zhao,chr(65) chr65 from dual 赵 A 3.select concat('0557-','88888888')||'-1234' tel from dua ...
First,here are some defination of date.   D :the day number of the week,example: Monday is two  DAY :the day name ,example:Monday   DD :  the day number of the month,from 0 to 31  DDD : the day number of the year, from 0 to 365   DY :  the day name for shot.  IW :  the week number of the year(ISO st ...

The Root

Let's talk about the roots. I am from the village remote.Just like the village of other areas in China,Poor seems stand for that,but I cannot agree with the one who think that deeply. Clean water,fresh air,the river we always go for swimming in summer always full of my mind.Pure character is the be ...
Controller components of struts mainly include:     ActionServlet: as a center controller of struts framework.     RequestProcessor:as the request processor of every sub applicaiton model.     Action: handle a detailed transaction main mission of them is:     1.receive the request of user.     ...
When use the encrypted arithmetic to encrypt some files.we can use the method create by MessageDigest: package com.CAHelper; import java.security.MessageDigest; import java.security.NoSuchAlgorithmException; public class MyTest { public static void main(String args[]){ String info = &q ...
When the collections want to evaluate the object is different from another object or not,it first to judge the mothod of hashcode() and equals() Set set = new HashSet(); Integer a = new Integer(10); Integer b = new Integer(10); set.add(a); set.add(b); System.out.println(a==b); ...
first ,create two tables you want to make the OR mapping. create table T_PASSPORT ( ID NUMBER(4) not null primary key, SERIAL VARCHAR2(30) not null ) create table T_PERSON ( ID NUMBER(4) not null primary key, NAME VARCHAR2(30) not null, AGE NUMBER(4) not null ) alter ta ...
In order to test hibernate example ,create a simple project is enough,then we shoule have these libs for simple test:hibernate3.jar,log4j-1.2.8.jar and the jar of oracle driver .add them to the liberary;   then generate the hibernate.cfg.xml and should put it in the classpath too. <?xml version ...
First ,you shoule download the opensource xtree.js for this function. /* * WebFXTreeItem class */ function WebFXTreeItem(sText, sAction, eParent, sIcon, sOpenIcon) { this.base = WebFXTreeAbstractNode; this.base(sText, sAction); /* Defaults to close */ if (webFXTreeConfig.usePersistenc ...
The content of this chapter is from Think in Java 3th ,bruce ecekl ArrayList  由数组实现的 List。允许对元素进行快速随机访问,但是向 List 中间插入与移除元素的速度很慢。ListIterator 只应该用来由后向前遍历 ArrayList,而不是用来插入和移除元素,因为那比 LinkedList 开销要大很多。LinkedList对顺序访问进行了优化,向 List 中间插入与删除的开销并不大。随机访问则相对较慢。(使用 ArrayList 代替。)还具有下列方法:addFirst(),addLast(),ge ...
When we use a css file ,we have a link at the head of html: <link type="text/css" href="css/main.css" rel="stylesheet"></link>   then we can define the style of css  in main.css and use it.ya,here we use the default media value: media = "all".th ...
For get the connection of oracle database ,you should add the oracle driver to the classpath first.and when you finished ,should close all the resouces. import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLExc ...
Some example for memory. create or replace procedure TQ_FirstProc is classname_value class %rowtype; begin select * into classname_value from class where class_id='2'; dbms_output.put_line(classname_value.class_number); end TQ_FirstProc; create or replace procedure TQ_Proc2 is class ...
Get the prime number between 100 and 150: create or replace procedure getPrime is l number(3):=101; k number(3); m number(3); begin while l < 150 loop k:= round(sqrt(l),0);--get the sqrt num of L ; m:=2; loop if mod(l,m)=0 then -- L is not the prime number m:=0; ...
Global site tag (gtag.js) - Google Analytics