SELECT regexp_replace('aa125s6df222bbbddddccc', '(.)\1+', '\1') FROM DUAL;
Résultat :
aa125s6df222bbbddddccc
a125s6df2bdc
SELECT table_name, COUNT (*) FROM all_tab_columns GROUP BY table_name ORDER BY COUNT (*) DESC
 |
|
select * from NATIONALITE where rownum < 2
MERGE INTO NATIONALITE A USING (SELECT 'YUG' as "NATIONALITE_ID", 'YOUGOSLAVE' as "NATIONALITE_LIBELLE" FROM DUAL) B ON (A.NATIONALITE_ID = B.NATIONALITE_ID) WHEN NOT MATCHED THEN INSERT ( NATIONALITE_ID, NATIONALITE_LIBELLE) VALUES ( B.NATIONALITE_ID, B.NATIONALITE_LIBELLE) WHEN MATCHED THEN UPDATE SET A.NATIONALITE_LIBELLE = B.NATIONALITE_LIBELLE; COMMIT;C’est tout simple avec Toad, cela facilite grandement la tache sur ce genre d’opération. (Pour le coup, un truncate, et Insert Statement aurait bien également bien fonctionner)
CREATE OR REPLACE PROCEDURE SU.REBUILD_INDEX (ma_table IN VARCHAR2)
IS
CURSOR CURS_REBUILD
IS
-- rebuild
select 'ALTER INDEX ' || index_name || ' REBUILD ' as txt_sql from user_indexes where UPPER(table_name) = UPPER(ma_table) and INDEX_TYPE!='LOB';
R1 CURS_REBUILD%ROWTYPE;
CURSOR CURS_STRUCT
IS
-- validate structure
select 'ANALYZE INDEX ' || index_name || ' VALIDATE STRUCTURE ' as txt_sql from user_indexes where UPPER(table_name) = UPPER(ma_table) and INDEX_TYPE!='LOB';
R2 CURS_STRUCT%ROWTYPE;
CURSOR CURS_STAT
IS
-- stat Analyse
select 'Analyze Table ' || UPPER(ma_table) || ' Estimate Statistics ' as txt_sql from dual;
R3 CURS_STAT%ROWTYPE;
BEGIN
---------rebuild ----------------------------------------------------
OPEN CURS_REBUILD;
LOOP
FETCH CURS_REBUILD INTO R1;
EXIT WHEN CURS_REBUILD%NOTFOUND;
EXECUTE IMMEDIATE R1.txt_sql;
END LOOP;
CLOSE CURS_REBUILD;
DBMS_OUTPUT.PUT_LINE('CURS_REBUILD 1 ok : TABLE : ' || ma_table);
----------validate structure---------------------------------------------------
OPEN CURS_STRUCT;
LOOP
FETCH CURS_STRUCT INTO R2;
EXIT WHEN CURS_STRUCT%NOTFOUND;
EXECUTE IMMEDIATE R2.txt_sql;
END LOOP;
CLOSE CURS_STRUCT;
DBMS_OUTPUT.PUT_LINE('CURS_REBUILD 2 ok : TABLE : ' || ma_table);
-----------stat Analyse--------------------------------------------------
OPEN CURS_STAT;
LOOP
FETCH CURS_STAT INTO R3;
EXIT WHEN CURS_STAT%NOTFOUND;
EXECUTE IMMEDIATE R3.txt_sql;
END LOOP;
CLOSE CURS_STAT;
DBMS_OUTPUT.PUT_LINE('CURS_REBUILD 3 ok : TABLE : ' || ma_table);
END;
/
select 'ALTER INDEX ' || index_name || ' REBUILD;' from user_indexes where table_name = 'MA_TABLE';
select 'ANALYZE INDEX ' || index_name || ' VALIDATE STRUCTURE;' from user_indexes where table_name = 'MA_TABLE';
Analyze Table MA_TABLE Estimate Statistics;
select wmsys.wm_concat(libelle) as LIBELLE, max(date_creation) as MA_DATE, CHIFFRE from maTable where critere = 1 and critere2 in (1,2,3) group by CHIFFRELe résultat
| LIBELLE | MA_DATE | CHIFFRE |
| -------- | ------------------- | ---------- |
| aa,bb,cc | 2007-11-19 | 44000 |
NHibernate.Dialect.Oracle10gDialect dial = new NHibernate.Dialect.Oracle10gDialect();
string sqlString = dial.GetSequenceNextValString("SEQ_NAME"); // génère Select SEQ_NAME.NEXVAL FROM DUAL
ISQLQuery sqlQuery = _session.CreateSQLQuery(sqlString);
return sqlQuery.UniqueResult().ToString();
La tentative de chargement des bibliothèques du client Oracle a renvoyé BadImageFormatException. Ce problème se produit en mode 64 bits avec les composants du client Oracle 32 bits installés.Tout simplement, c'est que le client Oracle installé sur votre machine n'est pas de type 64bits et donc de ce fait, l'application s'exécutant en 64bits pose souci !
ALTER TABLE SU.POSTS ADD ( CONSTRAINT BOOL_POSTISPUBLIC CHECK (ispublic=0 OR ispublic=1));
alter system flush shared_pool; alter system flush buffer_cache;