-
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.
-
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,
-
What does COMMIT do ?
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
rampratap409
- Dec 5th, 2006
Commit ends all previous transactions by making changes permanent in the datafile ( logicaly in tables)
-
What is the function of Optimizer ?
The goal of the optimizer is to choose the most efficient way to execute a SQL statement.
sravan1
- Dec 11th, 2006
The optimizer determines the most efficient way to use the tables and indexes to complete the request made by an SQL statement after considering many factors related to the objects referenced and the conditions specified in the query.
-
What is Execution Plan ?
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.
-
When does a Transaction end ?
When it is committed or Rollbacked.
-
What is SAVE POINT ?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in...
rampratap409
- Dec 5th, 2006
SavePoint: this is also a TCL command, which puts break points between DML statements so that you can rollback to any point and keeping some part of transaction in process.exampleupdate emp set ...
Data Access Interview Questions
Ans