-
Time taken by a query
What is the command to print the time taken by a query
hemant.agarwal03
- Feb 13th, 2008
you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time..
karunakaradepu
- Jan 29th, 2008
If UR Q is How TO PRINT A TIME: SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL;
-
How to query data from table which has "GROUP" as column name, since it's keyword?
madhupriya.nukala
- Feb 3rd, 2008
U have to use this gropu as a column by specifiying it in "doublequotes"
madhupriya.nukala
- Feb 1st, 2008
Hi,??? Send me mail if satisfied .Thanks.MadhupriyaSQL> create table string("group" varchar2(20),name varchar2(20));Table created.SQL> insert into string values('&group','&name');Enter value for gr...
-
How to go to command prompt when button pressed in D2k
vijay_orcl
- Jan 30th, 2008
you can use HOST commend.for examplehost('md c:vijay');it will create vijay directory on c drive.
-
What is MIS in software engineering?
-
Oracle 10g new features
Can anyone please tell me what are the advanced features in 10g when compared to 9i
kumar1974
- Jan 23rd, 2008
Oracle 10g features are 1) Sys Aux Tablespace 2) ASM3) New Flash Recovery Area 4) CTWR (Change Tracking Writer) This is background process which writes the block change information to the change tracking file. 5) Server Manageability Components6) Unified Job Schedular etc
-
How to delete user wise data in Oracle 9i?
-
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.
-
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;
Oracle Basics Interview Questions
Ans