Задание пароля пользователю в Oracle и установка паролю бесконечного срока жизни

ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
ALTER USER ${user} IDENTIFIED BY ${password} ACCOUNT UNLOCK;

Строка запроса к Oracle для выборки данных по дате

select * from documents where status= 'PROCESSING' and creation_date > to_timestamp('17-03-2015 17:40:00.123000','DD-MM-RR HH24:MI:SS.FF');

Pagination для Oracle

/**
* Создание запроса с разбиением по страницам (pagination) для Oracle
*/
protected String preparePaginatedQueryOracle(String originalQuery) {
        StringBuilder query = new StringBuilder();
        query.append("select * from (");
        query.append("select a.*, ROWNUM rnum from (");
        query.append(originalQuery);
        query.append(") a");
        query.append(" where ROWNUM <= ? )");
        query.append(" where rnum  >= ?");
        return query.toString();
    }

Удаление table, view, procedure, sequence из Oracle по маске

set serveroutput on size 1000000

BEGIN
FOR r IN(

  select TABLE_NAME
    from USER_TABLES
      where TABLE_NAME like 'NF\_%' escape '\')

LOOP

  execute immediate 'drop table ' || r.table_name || ' cascade constraints';

END LOOP;

FOR r IN (

  select SEQUENCE_NAME
    from USER_SEQUENCES
      where SEQUENCE_NAME like 'NF\_%' escape '\')

LOOP

  execute immediate 'drop sequence ' || r.SEQUENCE_NAME;

END LOOP;

FOR r IN (

  select VIEW_NAME
    from USER_VIEWS
   where VIEW_NAME like 'NF\_%' escape '\')

LOOP

  execute immediate 'drop view ' || r.VIEW_NAME;

END LOOP;

FOR r IN (

  select OBJECT_NAME
    from USER_PROCEDURES
      where OBJECT_NAME like 'NF\_%' escape '\')

LOOP

  execute immediate 'drop procedure ' || r.OBJECT_NAME;

END LOOP;

exception when others then
   dbms_output.put_line(sqlerrm);
END;
/