Application Developer must know SQL

Changing the password of  user
--------------------------------------
  Navigate to path  C:\oraclexe\app\oracle\product\11.2.0\server\bin

1.  login to the  sqlplus as sysdba

2. alter user system identified by <new_pass>

 Changing the password of the sysdba account
-----------------------------------------------
1. login as sqlplus   /nolog
2. con /as sysdba
3.alter user sys indetified by sysdba123

Unlocking the user acccount
==================

ALTER USER system ACCOUNT UNLOCK

Creating sequence  on the column
============================

http://sathyam-soa.blogspot.in/2012/07/adf-db-sequence-using-db-trigger.html

create sequence vendor_sequence
starts with 1
incremented by 1
nonmaxvalue;

-- Define the DB sequence at ADF level is the best choice
http://sathyam-soa.blogspot.in/2012/07/adf-db-sequence-using-db-trigger.html

http://waslleysouza.com.br/en/2014/09/using-database-sequence-adf/

 Creating the trigger on the table
==========================

create trigger  vendor_trigger
before insert on vendor
for each row begin
select vendor_sequence.nextval   into :new.vendorid from dual;


: SELECT SQL_ID,ELAPSED_TIME,(ELAPSED_TIME/1000000) as TimeInSec,buffer_gets, sql_text FROM SQLREP_SQLSET_STATEMENTS WHERE SQLSET_NAME='R13_PRC_VIN_SQL_REPORT'
AND SQL_ID IN ('31amya9qm5q4u',
'993hvbpudj04u',
'dw9p9wwt59ac4',
'59yhd8nwm3f17',
'37mvdw8bhfzw6',
'81srdc545ram5',
'4258878w8hjhv',
'2jnmh4qqf8s68',
'20yqp8z2m793v',
'97b93wxyqfsah',
'gnwj2r6jyd9rn',
'7gan7r6341udh',
'd171tkna91dw6')
order by TimeInSec;


 How many times function get executes
===============================




 begin
  
      dbms_application_info.set_client_info(0);
     end;
   
      select
   dbms_utility.get_cpu_time-:cpu cpu_hsecs,
    userenv('client_info')
    from dual;

 Code in function :
 dbms_application_info.set_client_info
       (userenv('client_info')+1 );

analytic_function([ arguments ]) OVER (analytic_clause)

The analytic_clause breaks down into the following optional elements.
[ query_partition_clause ] [ order_by_clause [ windowing_clause ] ]


  GRANT ALTER,DEBUG,DELETE,FLASHBACK,INDEX,INSERT,ON COMMIT REFRESH,QUERY REWRITE,REFERENCES,SELECT,UPDATE ON yogesh_tax TO fusion_runtime;