-
What values are stored internally for time (hour,minute ,second) if the date format is dd-mon-yy??
shanthi_9881
- May 8th, 2008
In sqlserver 2005 we can use as follows to retreive the date part of the given date or sys dateselect datepart(dd,getdate())
Dharmendra Gohil
- Sep 26th, 2006
Date Functions: =============Oracle stores dates in an internal numeric format:century,year,month,day,hours,minutes and secondsDefault display format is DD-MON-YYYYOracle stores...
-
How do I display row number with records
-
What is the maximum SIZE allowed for each type
G.D.S.Prasad
- Jun 21st, 2008
VARCHAR2: Max Size=4000 bytesCHAR: Max Size=2000 bytesNUMBER(p,s): The precision p can range from 1 to 38. &nbs...
Rama Krishna,Yerra
- Aug 2nd, 2006
The Max Size is upto 32.Thanks&RegdsRamki,TCS,Hyd
-
What is a corelated subquery
G.D.S.Prasad
- Jun 21st, 2008
It is a subquery which is evaluated once for each row processed by parent statement.
globalanil18
- Mar 31st, 2007
Hi Guys,The Oracle Server performs a correlated subquery when the subquery references a column from a table reffered to in the parent statement. A correlated subquery is evaluated once for each row pr...
-
What is difference between TRUNCATE & DELETE ?
TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.
nandk.sharma
- Jun 27th, 2008
Truncate is faster than delete as it does not generate rollback segment.
nandk.sharma
- Jun 27th, 2008
TRUNCATE - Truncate is a ddl command.DELETE- Delete is a dml command.TRUNCATE - We can not use 'where' clause with truncate.DELETE- We can use 'where ' clause with delete .
-
Can a view be updated/inserted/deleted
sweetytrivedi
- Jun 24th, 2008
If a view is based upon a single table then DML operations can be performed on it, while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers.
Srikanth
- Nov 7th, 2006
A view can be manpulated by using instead of triggers
-
User defined exception waste
In which section of a PL/SQL block is a user defined exception waste?
-
How do you set AutoComit off for DDL commands in Oracle Server? Is this Possible..?
vishakha_jain81
- Aug 12th, 2008
For DDL commands, We cannot do autocommit off. It is modify structure?of database object such as table, view and these commands have automatically commit.Set autocommit on/off is used for DML.
-
If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE
Gayathri Panchangam
- Sep 4th, 2008
Yes.Becoz sysdate contains date and time.For example: if u create a table like thiscreate table ex(id number,date1 date defualt sysdate unique);u get table created. After that if u insert rows in that...
-
How is the data inserted in the Index table when a new row is inserted into the main table on which the index is created ?
niteshaggarwal
- Oct 20th, 2008
The ROWID of that row and the Data value on which that index is created will be inserted in index file. ROWID have row address, which will locate the row at the physical level and thus accessing of that value will be fast.
-
Implicit Cursor attributes
Haraprasad
- Nov 3rd, 2008
SQL%ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed.
rampratap409
- Dec 7th, 2006
sql%isopen is there but it will always return "false" for implicit cursor
-
Display Odd/ Even number of records
sharmasl
- Mar 23rd, 2009
These are the querys:- FOR Odd number of records: select * from emp where (rowid ,1) in (select rowid, mod(rownum,2) from emp); FOR Even number of records: select * from emp where (rowid ,0) in (select rowid, mod(rownum, 2) from emp); try.........................
nandk.sharma
- Jun 30th, 2008
We can use the below query to get the odd record of the table --select r from (SELECT rownum r FROM EMP)where mod(r,2) != 0We can use the below query to get the even record of the table --select r from (SELECT rownum r FROM EMP)where mod(r,2) = 0
-
What is the output of SIGN function
sharmasl
- Mar 23rd, 2009
For - values it return (-1);for 0 it return (0);for + values it return (+1);
qwe
- Mar 29th, 2007
SIGN (a): Returns 1 if a is positive ,-1 if a is less than 0 and 0 if a is 0
-
How to drop the column in a table
sharmasl
- Mar 23rd, 2009
use the following syntex for drop the columnalter table emp drop column ename;
NARENDRA
- Dec 12th, 2006
Alter table?TABLENAME drop column?COLUMNNAME Generally rollback cant be followed are implemented along with these DDL statements. The commit statement automatically involves.
-
The use of HAVING , WHERE and GROUPBY in one SQL
thumatinagaraju
- Oct 23rd, 2006
Hiin where condition we cann't use group function but having clause allows it, both r used 4 data restriction only.group by is used 4 grouping similar items.
-
What are the types of SQL Statement ?
Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession Control: ALTERSESSION & SET ROLESystem Control : ALTER SYSTEM.
gdurga
- Jun 15th, 2009
DDL: Data Defintion LanguageDML: Data Manipulation LanguageTCL: Transaction Control LanguageDCL: Data Control Language
-
What are the different types of SQL
gdurga
- Jun 18th, 2009
1. DDL: Data Definition Language2. DML: Data Manipulation Language3. TCL: Transaction Control Language4. DCL: Data Control Language5. DQL: Data Query Language
-
To view installed Oracle version information
Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: select * from v$version;
-
Display the number value in Words
bhaskar1981buie
- Dec 4th, 2007
The number which have precesion can be spelled in words by this way..SELECT DECODE(SUBSTR(LPAD('1256932.1',DECODE(INSTR('1256932.1','.'),0,11,DECODE(LENGTH('1256932.1')...
-
To display the all employee name with end of ‘S’ without using like operator ?
goutamgeek
- Dec 23rd, 2009
select * from table_name where substr(first_name,length(first_name),1)='S'
SQL*Plus interview Questions
Ans