Jump to content

Archived

This topic is now archived and is closed to further replies.

Fahid

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

Recommended Posts

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

Share this post


Link to post
Share on other sites

[!--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]

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.