Home » SQL & PL/SQL » SQL & PL/SQL » how to delete rows from the table. (10g/REDHAT)
how to delete rows from the table. [message #337189] Wed, 30 July 2008 02:20 Go to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
Hello Everybody,

There is one table orders having one column orderno.
now i want to delete all the order placed 15 days ago.

Please be informed order table does not have any date column based on which we could fire the sql command.

Is it is still possible, then how?

Appreciate your help.

Thanks in advance.
Re: how to delete rows from the table. [message #337203 is a reply to message #337189] Wed, 30 July 2008 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it is still possible, then how?

No.

I want to kiss all men in red shirt, note I am blind, how can I do?

Regards
Michel
Re: how to delete rows from the table. [message #337256 is a reply to message #337203] Wed, 30 July 2008 05:23 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Kiss them all, and you'll certainly kiss all of them who wear red shirts too.

(However, I'd rather kiss girls in red shirts than men, but OK, we all have our preferences ./fa/1587/0/)
Re: how to delete rows from the table. [message #337257 is a reply to message #337256] Wed, 30 July 2008 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually, my first word was "kill" but as I had some comments last time about killing men, I just "s/l/s/". Wink
Still OK to "s/s/l/" everyone? ./fa/917/0/

Regards
Michel
Re: how to delete rows from the table. [message #337310 is a reply to message #337189] Wed, 30 July 2008 09:06 Go to previous message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
HAHAHAHA

Gud one Micheal/Littlefoot

I thought you people will help me in identifying those men in Red Shirt, but was not aware you too are facing the same crisis.

Anyways Thanks a lot for your quick response as always!!

regards,
Liam.

Previous Topic: Find the record causing ORA-01847: day of month must be ...
Next Topic: Materialized View: A Question
Goto Forum:
  


Current Time: Sat Dec 03 16:31:44 CST 2016

Total time taken to generate the page: 0.08477 seconds