Home » SQL & PL/SQL » SQL & PL/SQL » Basic query needed
Basic query needed [message #229910] Tue, 10 April 2007 05:12 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,


This is my table structure.

rollno name sal
84 clinton 200$
1002 martin 300$

i give an input value of rollno:&n

i want delete that record.for example i give an input 1002,
delete from that record only.How can i do it.I need query pls.



Arun.. Cool

Re: Basic query needed [message #229912 is a reply to message #229910] Tue, 10 April 2007 05:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Haven't you seen any sql DELETE statement?

By
Vamsi
Re: Basic query needed [message #229918 is a reply to message #229912] Tue, 10 April 2007 05:43 Go to previous message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
i am also new in oracle

delete from emp where rollno =&rollno


--Yash
Previous Topic: Merging two columns..
Next Topic: DDL statement on table on which materialized view is created
Goto Forum:
  


Current Time: Thu Dec 08 01:55:48 CST 2016

Total time taken to generate the page: 0.22011 seconds