Manual Waiting in Loop

 begin
for i in 1 .. 1
loop
dbms_output.put_line(to_char(sysdate, 'mi:ss'));
dbms_lock.sleep(.5);
end loop;
end;
/

File Transfer Using Oracle

 DBMS_FILE_TRANSFER.COPY_FILE(
   source_directory_object       IN  VARCHAR2,
   source_file_name              IN  VARCHAR2,
   destination_directory_object  IN  VARCHAR2,
   destination_file_name         IN  VARCHAR2);


BEGIN
DBMS_FILE_TRANSFER.COPY_FILE('DMPDIR',"expdp_28-07-Tue_23.00_PM.zip", 'DMPDIR',
                                   "expdp_28-07-Tue_23.00_PM2.zip");
END;

create or replace directory DMPDIR AS 'G:\';

create or replace directory DMPDIR2 AS 'G:\NEW';


BEGIN
  DBMS_FILE_TRANSFER.COPY_FILE(
   source_directory_object      => 'DMPDIR',
   source_file_name             => 'IMPORT.LOG',
   destination_directory_object => 'DMPDIR',
   destination_file_name        => 'IMPORT2.LOG');
END;
/


begin
UTL_FILE.FCOPY ('DMPDIR', 'expdp_28-07-Tue_23.00_PM.zip', 'DMPDIR', 'expdp_28-07-Tue_23.00_PM2.zip');
end;
/

Physical file existence check

DECLARE
  l_file_exists BOOLEAN;
  l_file_len    NUMBER;
  l_blocksize   BINARY_INTEGER;
BEGIN
  utl_file.fgetattr(
    location    => 'UTL_DIR',
    filename    => 'MM.TXT',
    fexists     => l_file_exists,
    file_length => l_file_len,
    block_size  => l_blocksize);
  IF l_file_exists THEN
    dbms_output.put_line('File found, size=' || l_file_len);
  ELSE
    dbms_output.put_line('File not found.');
  END IF;
END;

Getting data from oracle database to android device

 if (Build.VERSION.SDK_INT > 9) {
        StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
        StrictMode.setThreadPolicy(policy);
    }
    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");

        String url="jdbc:oracle:thin:@192.168.0.102:1521:orcl";
        String username="hr";
        String password="hr";
        Connection con=DriverManager.getConnection(url, username, password);
        Statement stmt=con.createStatement();

        ResultSet rs = stmt.executeQuery("select first_name from employees");
        StringBuilder stringBuffer = new StringBuilder();
        while (rs.next()) {
            stringBuffer.append(rs.getString(1) + "\n");
        }
        editText.setText(stringBuffer.toString());


        con.close();
} catch (SQLException e) {
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }

AUDIT TABLE

Audit_trail



ALTER SYSTE SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE

SHU IMMEDIATE
STARTUP

AUDIT ALL BY HR BY ACCESS;
AUDIT SELECT TABLE , UPDATE TABLE, INSERT TABLE, DELETE TABLE BY HR BY ACCESS;
AUDIT EXECUTE PROCEDURE BY HR BY ACCESS

VIEW AUDIT TRAIL

SELECT VIEW NAME
FROM DBA_VIEWS
WHERE VIEW_NAME LIKE 'DBA%AUDIT%'


BASE TABLE

DESC AUD$

SELECT USERNAME,EXTENDED_TIMESTAMP,OWNER,OBJ_NAME,ACTION_NAME FROM DBA_AUDIT_TRAIL
WHERE OWNER='HR'

SQL Tuning Advisor

DECLARE
  l_sql_tune_task_id  VARCHAR2(100);
BEGIN
  l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
                          sql_id      => '3rfdxk7fxh9b9',
                          scope       => DBMS_SQLTUNE.scope_comprehensive,
                          time_limit  => 60,
                          task_name   => '3rfdxk7fxh9b9_tuning_task11',
                          description => 'Tuning task1 for statement 87s8z2zzpsg88');
  DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);
END;
/


XEC DBMS_SQLTUNE.execute_tuning_task(task_name => '3rfdxk7fxh9b9_tuning_task11');



set long 65536
set longchunksize 65536
set linesize 100
select dbms_sqltune.report_tuning_task('3rfdxk7fxh9b9_tuning_task11') from dual;



execute dbms_sqltune.drop_tuning_task('3rfdxk7fxh9b9_tuning_task11');

EXP AND EXPDP

@echo off
REM
SET dirname="%date:~-7,2%-%date:~-10,2%-%date:~-4%"
mkdir \\192.168.1.99\Delowar-IT\EXP_BACKUP\%dirname%                     

set oracle_sid=ala
setlocal
for /f "tokens=1-4 delims=/ " %%a in ('date /t') do set DATE=%%c-%%b-%%a
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
set hours=%%a
set minutes=%%b
set ampm=%%c
)
if {%ampm%}=={AM} if {%hours%}=={12} set hours=00
if {%ampm%}=={PM} (
for /f "delims=0 tokens=*" %%a in ("%hours%") do set hours=%%a
set /a hours+= 12
)

E:\database2\product\11.2.0\dbhome_1\BIN\exp labserp/drockfantasi29@dba file=\\192.168.1.99\Delowar-IT\EXP_BACKUP\\%dirname%\lan_%date%_%hours%.%minutes%_%ampm%.dmp  log=\\192.168.1.99\Delowar-IT\EXP_BACKUP\\%dirname%\lan_%date%_%hours%.%minutes%_%ampm%.log statistics=none



@echo off
REM
SET dirname="%date:~-7,2%-%date:~-10,2%-%date:~-4%"
--mkdir \\192.168.1.99\Delowar-IT\EXP_BACKUP\%dirname%                     

set oracle_sid=ala
setlocal
for /f "tokens=1-4 delims=/ " %%a in ('date /t') do set DATE=%%c-%%b-%%a
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
set hours=%%a
set minutes=%%b
set ampm=%%c
)
if {%ampm%}=={AM} if {%hours%}=={12} set hours=00
if {%ampm%}=={PM} (
for /f "delims=0 tokens=*" %%a in ("%hours%") do set hours=%%a
set /a hours+= 12
)

E:\database2\product\11.2.0\dbhome_1\BIN\expdp labstest/labstest@bidba directory=expdp_dir dumpfile=expdp_%date%_%hours%.%minutes%_%ampm%.dmp logfile=expdp_%date%_%hours%.%minutes%_%ampm%.log network_link=source