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

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

[Url hiding for user authentication]

I have a web enabled application...the first screen is a log in screen...
I want to make a login screen designed using php...
How I can hide the url that sends the user information when logging in?
In another word, when I click on the link to open the web enabled program it should show me a popup window(it has no url) to enter username and password to log in the application...
This kind of security how can it be done?