Select statement comes under DQL(Data Query Language) statement. It is used to fetch data from Database. Data fetched from table stored in result set. Now we will explore the different option available with select statement. [Read more…]
Here we will discuss the some key areas of Oracle which will be usefull for Java beginners(Not Oracle Expert). [Read more…]
Here we will find the answer of all the How TO question in Oracle Database.
How to check the version of Oracle DB? ?
1 select banner from v$version
How to create synonym?
12 create synonym v_table for jbt_tablecreate public synonym v_table for JBT_function
How to check the current date/month.year?
123 select to_char(sysdate, 'dd') from dualselect to_char(sysdate, 'yyyy') Year from dualselect to_char(sysdate, 'mon') Year from dual
How to Extend or Decrease the Size of a Tablespace in Oracle?
Can we create index on view ?