Home » SQL & PL/SQL » SQL & PL/SQL » data to be inactive (oracle 10g)
data to be inactive [message #399638] Thu, 23 April 2009 04:36 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,

is there any possible way to inactive the existing data in a table and enter the same data into that table.
Re: data to be inactive [message #399640 is a reply to message #399638] Thu, 23 April 2009 04:49 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Your question is unclear. Please try to explain in more detail (remeber to follow the guidelines)
Re: data to be inactive [message #399643 is a reply to message #399640] Thu, 23 April 2009 05:00 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
i am having a table emrpatientsmaster in that one column is there like status.if status=1 then data will be active.now i am updating
that column to 0 to get inactive all the data and i want to insert
the existing data in it.
Re: data to be inactive [message #399646 is a reply to message #399643] Thu, 23 April 2009 05:14 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Are you saying that you want to change all of the values in this column that currently have a value of 1 to be set to 0?

If so, then look up the syntax for update
Re: data to be inactive [message #399854 is a reply to message #399643] Fri, 24 April 2009 04:58 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Why do you want to duplicate data?
Or I am taking it wrong?
Be clear if special reason.

regards,
Delna
Re: data to be inactive [message #399927 is a reply to message #399643] Fri, 24 April 2009 09:02 Go to previous messageGo to next message
rajesh.chamarthi
Messages: 11
Registered: November 2006
Junior Member
Where does the new data (that you want to insert) come from ?
Re: data to be inactive [message #399928 is a reply to message #399638] Fri, 24 April 2009 09:29 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Previous Topic: PLS-00306: wrong number or types of arguments in call to 'GET_DNAME_USING_ID'
Next Topic: Finding duplicate in table
Goto Forum:
  


Current Time: Sat Dec 03 00:52:53 CST 2016

Total time taken to generate the page: 0.07597 seconds