-
Select Updated Values
Without Using Update Statement on Database how we can Select the Updated values on a Object(Table,View or etc..)?
-
Combine Two Separate Tables
How to combine two separate table into one?
-
How SGA works if the user process issuing SELECT statement to the database?
dbashashi
- Jul 14th, 2009
Select statement works in the same way as other querries. The result set is brought from the Datafile if not already in Buffer cache. As we are aware that Buffer cache works on LRU and MRU algorithm ...
kishore.giri
- Dec 12th, 2007
When a query is submitted by the user it comes to the sharedpool and it is processed by the library cache i.e. statement is parsed their,execution plan is prepared and data is retrived from the datafi...
-
What is one time procedure
javedans
- Jul 8th, 2009
One time procedure, Its actually not a procedure but its called as one time procedure, Why because this used to initialize variable, calling function or procedure once the scope of package for user se...
Thulasidas
- Dec 5th, 2006
And the primary purpose of one time procedure is for one time initialisation of package variables
-
Determining static/dynamic parameters
How to determine whether particular parameter of parameter file is static or dynamic?
mps9029
- Jul 1st, 2009
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases 1) Immediate 2) DEFERRED 3) False 1. Immediate : We can change the parameter in fly database ie Dynami...
-
-
Disable Print Option
How to disable print option from the report preview?
adeelkamboh
- Jun 2nd, 2009
While calling the report, Add a parameter 'DISABLEPRINT' and set its value to 'NO'. Also note that you can also disable email button by doing the same with 'DISABLEMAIL' parameter.Hope that answers your question!
-
Insert Picture or Sound Clipping
How to insert a picture or sound clipping in Oracle Database?
-
How to apply the generated sequence on the tables?
gcvpgeek
- Mar 17th, 2009
Say you are using the seq name temp_seqCREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
VALUES (temp_seq.nextval,'oracle')lanka_satya
- Jul 4th, 2008
Dear friend : oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using <seq_name>.nextvalfor ...
-
How to delete duplicate values from tableFor Ex: A table contains 200 rows in that 100 rows are duplicate values, how to delete those 100 rows?
gcvpgeek
- Mar 17th, 2009
Use this simple querydelete from table1 where rowid not in (select max(rowid) from table1 group by duplicate_col_name)
srividhya_85
- Jul 6th, 2008
Hi, 'X' refers here to the table name and 'a' and 'b' are the alias nameDelete from X a where rowid in (select min(rowid) from X b &...
-
View SMON
How to view whether SMON is running or not using batch script??
-
Databases Interoperability
How two databases can be interoperabled?
-
Meta Data Query
What is the query to get meta and meta-meta data?
taraldesai
- Mar 4th, 2009
Every query is sort of query for metadata.select * from emp;Metadata for employee isn't it.
-
I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible.
daid_k
- Aug 21st, 2007
Drop the table? SYS.IDL_UB1$? for that location then you can Import witout error.
-
When we commit a transaction what sort of things happen in the oracle server ?
vijaydeep
- Mar 1st, 2009
Ends the current transaction by making all pending data changes permanent.Is the simplest way to define.Transaction means start with an DML SQL Statement and end with one of the following? 1) A commi...
sweetytrivedi82
- Apr 25th, 2006
when a commit occurs in the transaction then the points are as mentioned:-1)an SCN is created & record in redo log buffer2)LGWR writes from Redo log buffer to redo log files3)oracle shows commit complete4)locks now can be released
-
What is the different between Stand Alone Procedure and Package?
suresh.adqr
- Feb 18th, 2009
1. Procedure Overloading and Function Overloading Possible in Package. This? Overloading Concept Not Possible in Procedure.2.?Variables in Package we?Can use as a Global Variables. it's Not Possible in Procedure.
amikat
- Jun 3rd, 2008
Procedure is a named PL/SQL block tht is stored in the database.Package is a collection of functions and procedures stored within the database. Pkg consists of 2 parts 1. Specification - declares type...
-
Is Oracle is a Multidimensional database? If yes How?
aks
- Aug 19th, 2006
This statement is supported by the prescence of cube and rollup operators in oracle 9i which indicates that it is a multidimensional dbs
-
What is the difference between cold backup and hot backup
Read Best Answer
Editorial / Best Answer
ttparavindh- Member Since Jun-2007 | Jun 19th, 2007
Cold Backup- We can take the Backup while DB(eg. Oracle) is down.
Hot Backup-We can take the Backup while DB(eg. Oracle) is running.
Cold backup is a physical backup. During a cold backup the database is closed and not available to users. All files of the database are copied (image copy). The datafiles do not change during the copy so the database is in sync upon restore.
Used when:Service level allows for some down time for backup
Hot backup is a physical backup. In a hot backup the database remains open and available to users. All files of the database are copied (image copy). There may be changes to the database as the copy is made and so all log files of changes being made during the backup must be saved too. Upon a restore, the changes in the log files are reapplied to bring the database in sync. Used when:A full backup of a database is needed
Service level allows no down time for the backupkrishnaprasad.sola
- Feb 9th, 2009
Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo...
srk.srikanth
- Feb 8th, 2009
Cold Backup: Need to back up Database Files, Control Files, Online Redo Log files.Hot Backup: Need to back up Database Files, ControlFiles, Offline Redo Log files (archive files).
-
Rebuild Index
What is rebuild index, why do we need to rebuild the index?
saikatrana
- Feb 1st, 2009
If you want a table moved from its own tablespace to other, then you have to rebuild index.Command:Alter Index index_name rebuild online;
-
What is variable size when showing SGA?
Variable portionThe variable portion is called variable because its size (measured in bytes) can be changed. The variable portion consists of: • large pool (optional)Provides working space for rman (although rman will also work without large pool). • Shared pool The shared pool is used for objects that are shared among all users. For example: table definitions, PL/SQL definitions, cursors and so on.
sairavi.dba
- Jan 31st, 2009
In SGA, variable size is combination of shared pool, Java pool and Large PoolSQL> show sga;Total System Global Area 612368384 bytesFixed Size &n...
dheeraj narula
- Dec 27th, 2008
Dynamic SGA allows Oracle to set, at run time, limits on how much virtual memoryOracle uses for the SGA.So under dynamic(variable ) SGA portion, in intialization parameter file the parameterSGA_MAX_SI...
Oracle Basics Interview Questions
Read Best Answer
Ans