Didn't get any Oracle hits in a quick google, but I did find out that MySQL spells it USING:
You guys can go to otn.oracle.com and register for free to get access to all the documentation they've ever written. I've got an account there. I do get the odd oracle magazine sent to me though...
This is the DELETE syntax:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_8005.htm#sthref6065
This is the text version:
DELETE [ hint ]
[ FROM ]
{ dml_table_expression_clause
| ONLY (dml_table_expression_clause)
}
[ t_alias ]
[ where_clause ]
[ returning_clause ] ;Where dml_table_expression_clause is:
{ [ schema. ]
{ table
[ { PARTITION (partition)
| SUBPARTITION (subpartition)
}
| @ dblink
]
| { view | materialized view } [ @ dblink ]
}
| ( subquery [ subquery_restriction_clause ] )
| table_collection_expression
}I can paste more but the way it works is that I can only view each sub-part of the gammar separately so it's a pain in the butt to copy.
Chris
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
