Jump to content


Photo

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


  • Please log in to reply
2 replies to this topic

#1 Fahid

Fahid
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationPakistan

Posted 23 November 2005 - 04:42 AM

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
Back Again...

#2 eshta

eshta
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 05 April 2006 - 06:53 AM

[!--quoteo(post=321288:date=Nov 23 2005, 07:42 AM:name=Fahid)--][div class=\'quotetop\']QUOTE(Fahid @ Nov 23 2005, 07:42 AM) View Post[/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
[/quote]


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]

#3 Fahid

Fahid
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationPakistan

Posted 06 April 2006 - 01:49 AM

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.
Back Again...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users