create user newUser identified by userPassword; grant create session to newUser_ grant create table to newUser; GRANT create view TO newUser; GRANT CREATE SEQUENCE TO newUser; GRANT CREATE PROCEDURE TO newUser; GRANT CREATE ANY TRIGGER TO newUser; GRANT CREATE ANY TYPE TO newUser; alter user newUser quota unlimited on users;
BEGIN DBMS_SCHEDULER.DROP_JOB (‘TEST_JOB’); END; / BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => ‘TEST_JOB’, job_type => ‘PLSQL_BLOCK’, job_action => ‘UPDATE TABLE tblName set value=5;’, start_date => sysdate, repeat_interval => ‘FREQ=HOURLY; INTERVAL=1’, /* every one hour */ enabled => TRUE, comments => ‘Test_JOb’); END; / BEGIN DBMS_SCHEDULER.ENABLE (‘TEST_JOB’); END; /
BEGIN UTL_MAIL.SEND ( sender => ‘[email protected]’, recipients => ‘rst@yahoo.’, subject => ‘test Oracle’, message => ‘testing orcl’); END; /
BEGIN FOR cur_rec IN (SELECT table_name, constraint_name FROM user_constraints WHERE constraint_type = ‘R’) LOOP EXECUTE IMMEDIATE ‘ALTER TABLE ‘ || cur_rec.table_name || ‘ DROP CONSTRAINT ‘ || cur_rec.constraint_name; END LOOP; FOR cur_rec IN (SELECT object_name, object_type FROM user_objects) LOOP BEGIN EXECUTE IMMEDIATE ‘DROP ‘ || cur_rec.object_type || ‘ ‘ || cur_rec.object_name; EXCEPTION WHEN OTHERS THEN […]
SELECT * FROM (SELECT * FROM TEST_TABLE ORDER BY dbms_random.value) WHERE rownum <= 5; This will give 5 random rows from table.
you need follwing libraries to use javascript code in java. 1. Apache BSF : http://jakarta.apache.org/bsf/ 2. Mozilla Rhino : http://www.mozilla.org/rhino/ Sample Code: