Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

³£ÓõÄһЩORACLEÃüÁî

²éÕÒÊý¾Ý¿âÖÐËùÓÐ×ֶΠ ÒÔ¶ÔÓ¦µÄ±í
select C.column_name,C.TABLE_NAME from dba_tab_columns C where owner=''
²éÿ¸ö¿ÆÄ¿class ·ÖÊýscroǰÈýÃû
select id, name, class, scro
   from (select row_number() over(partition by class order by scro desc)  cnt,
                id,
                name,
                class,
                scro
           from student) a
  where a.cnt <= 3;
²éÕÒÅÅÐòºóµÄǰÈýÐÐ
  select *
  from (select rw.*, rownum
          from (select *
                  from student d
                 where d.class = 'b'
                 order by d.scro desc) rw
         where rw.id >= 1
         order by rw.class desc) n
where rownum <= 3
±í¸´ÖÆ
insert into table_a (id,name,age) select b.id,b.name,b.age from table_b;
--ɾ³ý±íÊý¾ÝµÄ´¥·¢Æ÷
CREATE OR REPLACE PROCEDURE delete_data
IS
BEGIN
   delete from test ;
   COMMIT;
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      NULL;
   WHEN OTHERS
   THEN
      RAISE;
END delete_data;
--¶¨Ê±É¾³ý  ÿ¸ô5·ÖÖÓÖ´ÐÐÒ»´ÎµÄ¼Æ»®
DECLARE
  X NUMBER;
BEGIN
  SYS.DBMS_JOB.SUBMIT
&nbs


Ïà¹ØÎĵµ£º

110¸öOracle ³£Óú¯ÊýµÄ×ܽá2

60.AVG(DISTINCT|ALL)
all±íʾ¶ÔËùÓеÄÖµÇ󯽾ùÖµ,distinctÖ»¶Ô²»Í¬µÄÖµÇ󯽾ùÖµ
SQLWKS> create table table3(xm varchar(8),sal number(7,2));
Óï¾äÒÑ´¦Àí¡£
SQLWKS> insert into table3 values(gao,1111.11);
SQLWKS> insert into table3 values(gao,1111.11);
SQLWKS> insert into table3 values(zhu ......

oracle splitº¯Êý

CREATE OR REPLACE TYPE ty_str_array IS TABLE OF VARCHAR2 (4000);
CREATE OR REPLACE FUNCTION fn_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)
    RETURN ty_str_split
IS
    j INT := 0;
    i INT := 1;
    len INT := 0;
 &nbs ......

ÈçºÎÅäÖòÅÄÜʹ¿Í»§¶ËÁ¬µ½oracleÊý¾Ý¿â

Ҫʹһ¸ö¿Í»§¶Ë»úÆ÷ÄÜÁ¬½Ó
oracle
Êý¾Ý¿â£¬ÐèÒªÔÚ¿Í»§¶Ë»úÆ÷Éϰ²×°
oracle
µÄ¿Í»§¶ËÈí¼þ£¬Î¨Ò»µÄÀýÍâ¾ÍÊÇ
java
Á¬½ÓÊý¾Ý¿âµÄʱºò£¬¿ÉÒÔÓÃ
jdbc thin
ģʽ£¬²»ÓÃ×°
oracle
µÄ¿Í»§¶ËÈí¼þ¡£¼ÓÈëÄãÔÚ»úÆ÷ÉÏ×°ÁË
oracle
Êý¾Ý¿â£¬¾Í²»ÐèÒªÔÚµ¥¶ÀÔڸûúÆ÷Éϰ²×°
oracle
¿Í»§¶ËÁË£¬ÒòΪװ
oracle
Êý¾Ý¿âµÄʱºò»á×Ô¶ ......

OracleµÄSQLÓï¾äÖÐÈçºÎ´¦Àí¡®&¡¯·ûºÅ

ÔÚOracleÖУ¬Èç¹ûÔÚsqlÖгöÏÖ'&'·ûºÅ£¬»á±»×Ô¶¯×ªÒ壻
¶ø±»ÒªÇóÊäÈëÔÚ&·ûºÅºó¸úËæµÄ×Ö·û´®µÄÖµ£¬ÀýÈ磺
update tablename set columnName='http://www.g.cn/cv2.jsp?spid=222&cid=333';
Ö´ÐÐÕâ¸ö²Ù×÷ʱ£¬Oracle»áÌáʾ
Enter value for cid:
Ô­ÒòÊÇÔÚOracleÖÐ & ·ûºÅÊÇ×÷ΪתÒå×Ö·ûʹÓõġ£
½â¾ö·½·¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ