Can Some one give me basic Oracle (SQL) queries ?

[Fahid]

I have been working with MySQL for some time, and doing quite well now.

But I have to work over a project that uses Qracle database.

So, if some one can give basic Qracle queries, like

 

in [!--coloro:#6600CC--][span style=\"color:#6600CC\"][!--/coloro--]MySQL[!--colorc--][/span][!--/colorc--]

SELECT `Name`,  `Email` FROM `users` WHERE `Name` LIKE 'Fahid'
INSERT INTO `users` VALUES('', 'NewName', 'NewEmail')
UPDATE `users` SET `Name`='UpdatedName' WHERE `Name` LIKE 'OldName'
DELETE FROM `users` WHERE `ID` LIKE `102`

SELECT `Title` FROM `jokes` ORDER BY `Title` DESC LIMIT 0, 50

and a few more like that, what you think are useful

[eshta]

[!--quoteo(post=321288:date=Nov 23 2005, 07:42 AM:name=Fahid)--][div class=\'quotetop\']QUOTE(Fahid @ Nov 23 2005, 07:42 AM) 321288[/snapback][/div][div class=\'quotemain\'][!--quotec--]

I have been working with MySQL for some time, and doing quite well now.

But I have to work over a project that uses Qracle database.

So, if some one can give basic Qracle queries, like

 

in [!--coloro:#6600CC--][span style=\"color:#6600CC\"][!--/coloro--]MySQL[!--colorc--][/span][!--/colorc--]

SELECT `Name`,  `Email` FROM `users` WHERE `Name` LIKE 'Fahid'
INSERT INTO `users` VALUES('', 'NewName', 'NewEmail')
UPDATE `users` SET `Name`='UpdatedName' WHERE `Name` LIKE 'OldName'
DELETE FROM `users` WHERE `ID` LIKE `102`

SELECT `Title` FROM `jokes` ORDER BY `Title` DESC LIMIT 0, 50

and a few more like that, what you think are useful

 

 

Hi Fahid...

You can download this link that includes information about SQL and PL/SQL. They are very usefull

[a href=\"http://3ssom.com/uploader/uploads14/learning.zip\" target=\"_blank\"]http://3ssom.com/uploader/uploads14/learning.zip[/a]

[Fahid]

Thanks a lot eshta

 

I thoought no one is ever gonna post any reply this thread.

Thanks, I am just downloading the file in link above and hope i help me.