Archive

Posts Tagged ‘SQL’

April 26, 2017 Leave a comment

Create a synonym in oracle database.
create or replace synonym my_schema_granted.my_db_object_synonym for schema_that_grants.db_object;
commit;

Categories: Mini-tips, Oracle, plsql, SQL

Get all days between two dates in oracle sql

March 30, 2017 Leave a comment
select to_date('30-03-2017','dd-mm-yyyy') + rownum -1
from all_objects
where rownum <= to_date('30-04-2017','dd-mm-yyyy')-to_date('30-03-2017','dd-mm-yyyy')+1;
Categories: Oracle, Programación, SQL

Query to know what changed in your database objects

January 18, 2016 Leave a comment

select last_ddl_time, object_name, object_type
from dba_objects
where last_ddl_time is not null
order by 1 desc;