-
How data flows from Hyperion DRM to other applications?
How financial data flows from DRM to other Planning and HFM applications using FDM.
-
-
-
Indexes in a sql query issue
we have a table that contains around 25,00,000 rows.The where clause is on month-year. Indexes in a sql query are picking up sometimes but the same query is not picking same indexes at different time
The query is picking up the index some times but the exactly same query is not picking those indexes when we checked later.
we have analyzed table,rebuilt index but it is still not... -
How to subtract 2 dates in oracle to get in hour and minute
I want to subtract 2 dates and represent the result in hour and minute in one decimal figure.
I have the following table and i am doing it in this way but the result is not as desired.
There is some slight variation, im sure this is simple arithmetic but im not getting it right.
select start_time, end_time, (end_time-start_time)*24 from come_leav;
START_TIME... -
How we can transform the columns of a table in rows ?
ravinder lathwal
- May 4th, 2012
Using pivot option in SQL server 2008.
-
Information about a particular disk
There are show many hard disks attached in system, how i know a particular disk information in solaris operating system?
-
Application of cursors in different applications
i am in a dilemma in thinking how different types of cursors are useful in applications.
like dynamic scrollable cursors are used where result set changes are reflected like in airline reservation system..
but can you tell me the usage of insensitive scrollable cursor(in which application) in real world..
and when to use unscrollable cursors(even though scrollable are... -
How to subtract 2 dates to get the result in hour and minute
Hi there..
I have 2 date fields in my table. I want to subtract these 2 date fields to get the result in hour and minute.
Below is what I have and what I am doing but the result is not as I want..
Date1 Date2 date2-date1*24 (is what I am doing)
21-06-2011 14:00:00 21-06-2011 16:55:00 2.9166667 -
Find users running the script
How do you find the users who are running the script ?
-
How to find that when and which record inserted in the table ?
girish1983
- May 5th, 2010
Here, we can enable the auditing on Database level.As such we come to know which user has done what tasks and on which objects and at what time.But for it DB has to be put in auditing mode.
dj_dj_dj
- Jun 11th, 2009
Most simple way is to write an Insert trigger on the table which you want to get audited.
-
How to add data from excel sheet to oracle database?
sudhagargeek
- Apr 27th, 2010
Try and let me know.. surely it will help you..1. Create excel sheet and enter column name with data and save sheet as .csv (employee.csv) extension.2. Open notepad and write theose lines as follows a...
ritikaag2002
- Sep 29th, 2008
it can be inserted using insert statement :="insert into R1 values('"&A2&"','"&B2&"','"&C2&"','"&D2&...
-
How can Restrict the row through View.
1)How can restrict the view through view2)What does prior statement in pl/sql3)What are the different Pragam inPL/sql except Pragam_init,pragma_Automation
MaheshRamekar
- Jun 10th, 2009
1)How can restrict the view through viewAdding where clause2)What does prior statement in pl/sqlGenerate hierchy tree3)What are the different Pragam inPL/sql except Pragam_init,pragma_AutomationPragma_init - to trap the expection pragma_automation - to execute the pl/sql block autonomusly.
-
Can we delete tuples in a table based on date column? And how?
MaheshRamekar
- Jun 10th, 2009
SQL> create table m( n number);Table created. 1* insert into m values(&1)SQL> /Enter value for 1: 1old 1: insert into m values(&1)new 1: insert into m value...
vishnu
- Sep 5th, 2006
If you want to delete rows with given DATE
DELETE FROM TABLE_NAME WHERE DATE_COLUMN = GIVEN DATE;
If you want to delete rows >= given DATE
DELETE FROM TABLE_NAME WHERE DATE_COLUMN >= GIVEN DATE;
If you want to delete rows -
There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
By creating a function for sorting in the front end(guessing, i am not sure. plz answer it)
sateesh240
- May 7th, 2009
Read character column into a PL/SQL table of numeric data type by converting to number, pass the PL/SQL table to JavaScript as a parameter, this is one way..?
rampratap409
- Dec 4th, 2006
use: select to_number(rollnumber) from tname order by to_number(rollnumber);orselect rollnumber from tname order by to_number(rollnumber);convert the value to integer in java
-
Oracle Mutation error
Please explain about Mutation error in database trigger in oracle with an example
srinivasanram2004
- Jul 25th, 2008
This error occurs when you try to select rows from a table and try to update the rows of the same table. Most developers face this problem. To avoid getting this error, create views, select the rows from the views, and then try to update the original table rows.
-
Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.
rajivd
- Dec 1st, 2007
Transaction is a process by which we take the database from one consistent level to another consistent level. A transaction is said to be completed only when we supply COMMIT and apply the changes to the database.
ddkdhar
- Feb 18th, 2007
A logical unit of work that comprises dml statements or it is the time between two committs or one and one rollback
-
-
-
How to choose between indexing and partitioning , to make query faster.
praveenladdu1
- Mar 6th, 2007
Generally we use partinioning for large databases ( if a huge collection of data is there). indexing is the first most process to fast query result,
Data Access Interview Questions
Ans