It won't, Because SYSDATE format contains time attached with it.

Ashima Chhabra

• Jun 20th, 2015

No...you can save a single row with the sysdate but not more than 1 on same date because format of date is YYYY-MM-DD and format of datetime is YYYY-MM-DD hh:mm:ss[.nnn] and format of smalldatetime is YYYY-MM-DD hh:mm:ss

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

yes with unique constraint on date column we can have same date becuase internally date is stored as  dd-mon-yyyy hh:mi:ss

Answer Question  Select Best Answer

sandeep dasari

• Jul 6th, 2006

by using alter table we can alter only column not the rows. by using alter  command we write query like this........alter table table_name add column_name datatype;for drop that column ;alter table table_name  drop column_name datatype;it's the answer.

Abdul Mannan

• May 28th, 2006

To insert a column in a table dml command should be used i.e., INSERT. A column cannot inserted in a table through ALTER command - only the data in a table is modified thru alter.

Answer Question  Select Best Answer

raghav_sy

 Profile Answers by raghav_sy Questions by raghav_sy

• Jan 24th, 2007

hi,some additions to Ram pratap answer:There are actually two types of triggers: DATABASE and APPLICATION triggers.Database triggers are of three types:1)DML trigeers: we can have a total of 12 DML t...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

cascading is used where primary/foreign key relation:by using cascade we can delete child record or can be set to null or default values

Answer Question  Select Best Answer

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

Multiple transaction can be controlled by three ways:1. COMMIT       : Make changes done in  transaction permanent.2. ROLLBACK  : Rollbacks the state of da...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

Use savepoint after each DML statement. If using procedure/function then do not give commit in them. commit in proc/function will erase your savepoints.

Answer Question  Select Best Answer

sandip01

 Profile Answers by sandip01 Questions by sandip01

• May 25th, 2010

ROWID is internally constructed when a new row is added.BBBBBB.RRRRRR.FFFFFFBBBBBB - Represents the blocks in the datafile.RRRRRR - Represents the rows in the block.FFFFFF - Represents the file no.

imtiazali

 Profile Answers by imtiazali Questions by imtiazali

• Jun 5th, 2009

Rowid and Rownum are psuedocolumns for every table Oracle provides unique rowid, rownum.Rowid are in alphanumeric, rowid are 18 character, for every rowid last 3 character will be changed.

Answer Question  Select Best Answer

ranadhee_85

 Profile Answers by ranadhee_85 Questions by ranadhee_85

• Feb 9th, 2011

There are 5 types of datatypes 1.Numeric Datatype2.character Datatype3.LargeobjectsDatatype4.Rowiddatatype5.Time/Datedatatype

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 15th, 2008

There is no restiction on number of datatypes allowed except for long and LOB.I table can contain only one long column.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Shivani Goel  

 Profile Answers by Shivani Goel Questions by Shivani Goel

• Member Since Jun-2009 | Jun 23rd, 2009

---

Referential integrity constraint is that which depend upon the parent and child relationship.  In this one of the column have the primary key constraint and one of the column of another table have the foreign key constraint. So you cannot delete the column value which having the foreign key constraint until you never delete its related primary key column value from parent table. If you tried to do this it will show you error related to referential integrity constraint.   But if you still want to delete value from child table but never want to delete parent table column value then that purpose you can use 'on delete cascade' option.

kierthi

• Aug 16th, 2011

A feature provided by relational database management systems (RDBMS's) that prevents users or applications from entering inconsistent data. Most RDBMS's have various referential integrity rules that y...

Shivani Goel

 Profile Answers by Shivani Goel Questions by Shivani Goel

• Jun 23rd, 2009

Referential integrity constraint is that which depend upon the parent and child relationship.  In this one of the column have the primary key constraint and one of the column of another table h...

Improve Answer

Lavanya Chowdary

• May 6th, 2007

Months_between(date1,date2) returns the number valueno other date functions return number value

sudhaker

• Dec 28th, 2006

to_char will also give number valueselect to_char(hiredate,'d') from emp

Answer Question  Select Best Answer

sharmasl

 Profile Answers by sharmasl Questions by 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

Answer Question  Select Best Answer

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

It is a subquery which is evaluated once for each row processed by parent statement.

globalanil18

 Profile Answers by globalanil18 Questions by 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...

Answer Question  Select Best Answer

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by 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.

lovely sethii

 Profile Answers by lovely sethii Questions by lovely sethii

• Jun 17th, 2008

By using set autocommit on we can do it

Answer Question  Select Best Answer

shanthi_9881

 Profile Answers by shanthi_9881 Questions by 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...

Answer Question  Select Best Answer

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

A natural join will join two datasets on all matching column names, regardless of whether the columns are actually related in anything other than name.SELECT d.dname, d.loc, e.ename, e.job FROM dept d...

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 7th, 2008

It implicitly construct the join condition on the 2 tables taking all the column with same name into consideration.Natural join is also called blind join.select? employee_id,last_name,department_name from employees natural join departments;

Answer Question  Select Best Answer

shailendra

• Aug 22nd, 2012

You can add 1024 column in the one table.

vik_ora

 Profile Answers by vik_ora Questions by vik_ora

• Apr 17th, 2008

Hi guys I am new to Oracle. Thank you for sharing your knowledge.

Answer Question  Select Best Answer

nabajit_oracle

• Mar 5th, 2007

Commit to like making all the changes permanently in the Server...But in case of GO statement which is available In SQL Server(TSQL), the set of steps before the GO statement is complied at once and s...

Varun Dixit

• Nov 10th, 2006

Hi Shweta,My mail id is varun.dixit@india.birlasoft.com

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Zimmy

• Jul 10th, 2005

---

ROWID is the psedo columns indicate the stored location of the data physically in the database.

Ravi

• Jul 3rd, 2013

ROWID: It is pseudo column,it has physical address location of row in ORACLE database
The format is: OOOOOO.FFF.BBBBBB.RRR
OOOOOO is the object ID
FFF is the file number
BBBBBB is the block number
RRR is the row number

vikas

• Dec 21st, 2012

But according to you it has 16 digits ... and according to my oracle 10g it is showing 18 digits. like AAAC9EAAEAAAABXAAA .. why??

Improve Answer

Read Best Answer

Editorial / Best Answer

Gayathri Panchangam  

 Profile Answers by Gayathri Panchangam Questions by Gayathri Panchangam

• Member Since Aug-2008 | Sep 5th, 2008

---

Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype.

Gayathri Panchangam

 Profile Answers by Gayathri Panchangam Questions by Gayathri Panchangam

• Sep 5th, 2008

Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, tha...

Nikhil_4_Oracle

• Mar 5th, 2007

Hey all,  You can have only one column of long in table , And this table can`t have  Primary key Constraint.             --Nikhil 

Improve Answer

sweetytrivedi

 Profile Answers by sweetytrivedi Questions by 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

Answer Question  Select Best Answer

How do you get back into SQLPlus to disable restricted session if you enabled.

sandeep

• Jun 30th, 2017

First of all login with sysdba,
Use the query..
Alter system disable restricted session;
this query disable restricted session

Lanie Acosta

• Aug 27th, 2015

Yes

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: srinivasan

• Aug 16th, 2005

---

A varchar2 datatype, when stored in a database table, uses only the space  
allocated to it. If you have a varchar2(1999) and put 50 bytes in the table, we  
will use 52 bytes (leading length byte). 
 
A char datatype, when stored in a database table, always uses the maximum length  
and is blank padded. If you have char(1999) and put 50 bytes into it, it will  
consume 2001 bytes (leading length field is present on char's as well). 
 
In the database -- a CHAR is a VARCHAR that is blank padded to its maximum  
length. 

Nitin Yadav

• Nov 9th, 2017

Char is fixed and varchar 2 is variable.

gopalakrishna

• Jul 28th, 2015

Char is a data type based on the given size memory is used
varchar2 based on the given characters memory is used

Improve Answer