-
In Oracle what manages memory, SGA or background processing?
kishore.giri
- Dec 17th, 2007
That is background processes because SGA is the memory area allocated during instance startup.
-
What are the differences between rownum and level pseudo columns?
gpsaravanan202
- Dec 12th, 2007
The only difference between rownum and level pseudocolumn isRownum is used to order the datas according to their ranks and it is used in inline views..Level pseudocolumn is used in hierarchial retrival of database.....
-
In which format data will be stored in Database(Oracle) ?
Find it imm...
kishore.giri
- Dec 12th, 2007
For the machine point of view data is stored in binary format.But if we say from database point of view it is stored in unicode format.
-
Is it neccessary to take backup of undo tablespace while taking hot backup?
kishore.giri
- Dec 12th, 2007
It is not necessary if your database is running in archivelog mode i.e. automatic archiving is enabled.
-
What is the advantage of table level constraints over column level constraints?
kishore.giri
- Dec 11th, 2007
In table level constraints, a single constraint can be created on more than one columns but it is not possible in case of column level constraints.A table level column can be created after the creation of the table without altering the column definitions.
-
Nls_date_format
How to set NLS_DATE_FORMAT for a database permanentlyfor example let's say I want to set : NLS_DATE_FORMAT= 'dd:mon:yyyy hh24:mi:ss' for the database and I am not supposed to give the ALTER SESSION command at every statrtup of the database.Plz try it practically and give me a solution
-
How to recover a table which is already been droped?
kishore.giri
- Dec 10th, 2007
If the database is running in archivelog mode then perform time-based recovery to recover the table.
-
What are the commands that come in the category of DML in SQL?
DML refers to Data Manipulation Statements. That is used for accessing and modifying values or data present in the database.
The commands that come in the category of DML in SQL
INSERT
SELECT
DELETE
UPDATE
INSERT:
This command is used to insert rows into the table.
SYNTAX:
INSERT INTO tablename...kishore.giri
- Dec 10th, 2007
The DML is for Data Manipulation Langugae i.e. those commands comes into picture that modifies datavalues in the database.The DML commands are INSERT,UPDATE,DELETE,MERGE.Some body answers that&n...
-
How to remove the duplicate value row using self join in Oracle !! please assist
RenukaRajput
- Nov 29th, 2007
delete table_name where col_name in(select col_name from table_name group by col_name having count(*) > 1)
Mital Mehta
- Oct 12th, 2007
Kasi , you are right but the syntax is Wrong .if u write delete * it will not work .u have to write like this way delete from test where rowid>(select Min(rowid) from test t where t.ename=test.ename)
-
Import Excel File to Oracle
Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.
xuqinglei2000
- Nov 21st, 2007
Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy the data from excel to the database;
-
How to increase the size of shared pool?
-
What are the datatypes available in SQL for storing a number other than NUMBER datatype?
rajakumar_na
- Nov 17th, 2007
1. float 2. decimal 3. double precision 4. int 5. integer 6. numeric 7. real 8. smallint
-
When to use synonym and when to not use synonym?
rajakumar_na
- Nov 17th, 2007
Use synonym when a table name or view name is too long, and if u want to give access permission of your table or view is accessed by all users (i.e. PUBLIC).
-
What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer?
rajakumar_na
- Nov 17th, 2007
One more point Bind variables are declared outside the pl/sql block whereas declare variables are declared with in the pl/sql block
jamesravid
- Jul 18th, 2007
Bind variables are command line parameters.whereas declare variables are variables local variables declared with in the pl/sql code.scope of declare variables is within the procedure you can't use them outside of the pl/sql code. But bind variables are valid till the session is valid
-
How to set the default values in Oracle using Alter command?
rajakumar_na
- Nov 16th, 2007
Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr)
taraldesai
- Jun 23rd, 2007
Specify parameter there is nothing like you are asking..like alter system set default ... wrongalter system set sql_trace=TRUE;
-
What are the different types of joins and explain in brief how to use them ?
rajakumar_na
- Nov 16th, 2007
Hi shravanam,Wht is this u r wrong?Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)
shravanam
- Oct 24th, 2007
Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi Join - ...
-
How to insert more then one record from one table to another table in oracle,in some specific colums
ROHIT_4444
- Mar 27th, 2007
SUPOOSE WE HAVE TWO TABLE R_ITEM_MASTER & ITEM_MASTERIN R_ITEM MASTER THERE ARE ITM_ITEM_CODE,ITM_DESC,ITM_UM,ITM_CURR_COST_RATE FOUR FIELDS BUT WE WANT TO INSERT RECORDS ONLY IN TWO COLUMSINSERT INTO R_ITEM_MASTER (ITM_ITM_CODE,ITM_UM) SELECT ITM_ITEM_CODE,ITM_UM FROM ITEM_MASTER
-
What are the differences between stored procedures and triggers?
Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures which are attached to a specific database object say a table. Stored procedures are not automatically run...
Amol Bawane
- Nov 15th, 2007
The basic difference between stored procedure and trigger is stored procedure can call explicitly, but trigger cannot call explicitly.Genarally trigger are used for Audit and trail. What should be the...
gvvskumaran
- Jan 15th, 2007
* procedures will be called by user or by programs* Trigger will be executed or triggered only when it is fired....
-
-
How can we execute dynamic SQL From PL/SQL block?
rajakumar_na
- Nov 14th, 2007
here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE...
Oracle Basics Interview Questions
Ans