Database Interview questions
codersmagJune 13, 2017
1) Define Database. A prearranged collection of figures known as data is called database. 2) What is DBMS? Database Managemen...
Read
Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts
Show line number in oracl ADF Jdeveloper
UnknownJuly 27, 2016
From the structure window, right click on your first column and choose Insert before af:column → column from the menu. Still in th...
Read
Display Table Row Count in Oracle ADF Jdeveoper
UnknownJuly 27, 2016
In order to display row count in oracle JDeveloper Just just estimatedRowCount value binding of output text
Read
Query to get last month data form table in Oracle
UnknownMay 06, 2016
select * from sale_master where transdate>= TRUNC(ADD_MONTHS(SYSDATE, -1),'MM') and transdate <= LAST_DAY(ADD_MONTHS(SYSDAT...
Read
List all Stored Procedures from Oracle Database
UnknownApril 25, 2016
SELECT * FROM User_Procedures; SELECT * FROM DBA_Procedures; SELECT * FROM User_Source WHERE name = 'stored_proc...
Read
Select one day back from database
UnknownApril 25, 2016
I used BETWEEN because the date column is likely DATETIME (on MySQL & SQL Server, vs DATE on Oracle), which includes the time portion...
Read
Subscribe to:
Posts
(
Atom
)
