eCharcha.Com   Support eCharcha.Com. Click on sponsor ad to shop online!

Advertise Here

Go Back   eCharcha.Com > Science and Technology > Computing

Notices

Computing All things binary...

Reply
 
Thread Tools Display Modes
  #1  
Old June 19th, 2006, 04:07 PM
dirty's Avatar
dirty dirty is offline
Super eCharchan
 
Join Date: Dec 2000
Location: SoCal USA
Posts: 11,308
dirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond repute
Oracle

Anyone has link to simple Oracle SQL command syntax ?
__________________
Fair use is a limitation and exception to the exclusive right granted by copyright law to the author of a creative work. In United States copyright law, fair use is a doctrine that permits limited use of copyrighted material without acquiring permission from the rights holders. Examples of fair use include commentary, criticism, news reporting, research, teaching, library archiving and scholarship. It provides for the legal, unlicensed citation or incorporation of copyrighted material in another author's work under a four-factor balancing test.
Reply With Quote
  #2  
Old June 19th, 2006, 06:15 PM
Sane Less's Avatar
Sane Less Sane Less is offline
Dead On Arrival is back
 
Join Date: Jun 2005
Posts: 17,280
Sane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond repute
Re: Oracle

DB2 gaya, ab Oracle aa gaya, Diytr pai?

SQL syntax is sem sem on all databases... check Visual Studio help.
__________________
-----------------------------------------------

"Kisi ne sahi kaha zindagi kutti cheez hai. You live life without a care in the world not realizing that life is building a heavy load of trash that it dumps on you one fine day, breaking your back." - saneless
Reply With Quote
  #3  
Old June 19th, 2006, 08:10 PM
GunsNRoses's Avatar
GunsNRoses GunsNRoses is offline
Spear Barbarian
 
Join Date: Jun 2001
Posts: 1,263
GunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud ofGunsNRoses has much to be proud of
Re: Oracle

Quote:
Originally Posted by Sane Less
SQL syntax is sem sem on all databases... check Visual Studio help.
Incorrect. SQL stands for Structured Query Language, not Standard Query Language. Even something as simple as selecting 10 rows from a table has different syntax for different engines.

@dirty - Are you looking for PL/SQL by any chance?
__________________
"Pick up your balls and load up your cannon
For a twenty-one gun salute."
-- For Those About To Rock (We Salute You)

Proud LLKC member since May 2002.
"We've been looking for the enemy for some time now. We've finally found him. We're surrounded. That simplifies things." Lt. Gen. Lewis "Chesty" Puller, USMC, Chosin Reservoir 1950

Reply With Quote
  #4  
Old June 19th, 2006, 10:49 PM
dirty's Avatar
dirty dirty is offline
Super eCharchan
 
Join Date: Dec 2000
Location: SoCal USA
Posts: 11,308
dirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond repute
Re: Oracle

Quote:
Originally Posted by GunsNRoses
Incorrect. SQL stands for Structured Query Language, not Standard Query Language. Even something as simple as selecting 10 rows from a table has different syntax for different engines.

@dirty - Are you looking for PL/SQL by any chance?
Correct . Earlier the database was SQL Server . Now it is Oracle . They have differant syntaxes. For instance I sued ISNULL is SQL server & Oracle may have some differant syntax. I am looking for a web-site where I can do a quick search on simple SQL sytaxes. Various commands I used in SQL-Server are not supported in Oracle . Not writing any PL/SQl or triggers just querying the databse but advanced querying.Hence the dilema.
__________________
Fair use is a limitation and exception to the exclusive right granted by copyright law to the author of a creative work. In United States copyright law, fair use is a doctrine that permits limited use of copyrighted material without acquiring permission from the rights holders. Examples of fair use include commentary, criticism, news reporting, research, teaching, library archiving and scholarship. It provides for the legal, unlicensed citation or incorporation of copyrighted material in another author's work under a four-factor balancing test.
Reply With Quote
  #5  
Old June 20th, 2006, 01:00 AM
desichacha's Avatar
desichacha desichacha is offline
Senior eCharchan
 
Join Date: May 2001
Posts: 1,012
desichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant futuredesichacha has a brilliant future
Re: Oracle

I am must stay both of u GNR and Dirty bit right and bit wrong...

SQL is a standard and everyone has implementations with certain 'extensions' and features....what is diff are those extensions and features
... pure SQL standards ( and way of writing query) is same across all database engines

my two cents
__________________
LLKC - Since 2001 ( proven in 2002 end ....long story)

Checkout where I and Randheer and few others blog - http://www.4octave.com
Reply With Quote
  #6  
Old June 20th, 2006, 01:39 AM
Napolean Napolean is offline
Senior eCharchan
 
Join Date: Jul 2001
Posts: 8,916
Napolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond repute
Re: Oracle

try oracle technolgy network...
http://otn.oracle.com
Reply With Quote
  #7  
Old June 20th, 2006, 05:46 AM
TerminatorJR's Avatar
TerminatorJR TerminatorJR is offline
Banned
 
Join Date: Nov 2004
Posts: 4,006
TerminatorJR has much to be proud ofTerminatorJR has much to be proud ofTerminatorJR has much to be proud ofTerminatorJR has much to be proud ofTerminatorJR has much to be proud ofTerminatorJR has much to be proud ofTerminatorJR has much to be proud ofTerminatorJR has much to be proud of
Re: Oracle

Quote:
Originally Posted by dirty
Not writing any PL/SQl or triggers just querying the databse but advanced querying.Hence the dilema.
Plz post the query dirty. EC resident experts will be better equipped to answer your query and the solution may help others too.



(Who knows it might be what I have been looking for too. )
Reply With Quote
  #8  
Old June 20th, 2006, 03:42 PM
dirty's Avatar
dirty dirty is offline
Super eCharchan
 
Join Date: Dec 2000
Location: SoCal USA
Posts: 11,308
dirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond reputedirty has a reputation beyond repute
Re: Oracle

Quote:
Originally Posted by TerminatorJR
Plz post the query dirty. EC resident experts will be better equipped to answer your query and the solution may help others too.



(Who knows it might be what I have been looking for too. )
Can't post here Bro. Proprietary data
__________________
Fair use is a limitation and exception to the exclusive right granted by copyright law to the author of a creative work. In United States copyright law, fair use is a doctrine that permits limited use of copyrighted material without acquiring permission from the rights holders. Examples of fair use include commentary, criticism, news reporting, research, teaching, library archiving and scholarship. It provides for the legal, unlicensed citation or incorporation of copyrighted material in another author's work under a four-factor balancing test.
Reply With Quote
  #9  
Old June 23rd, 2006, 12:53 PM
Mr_Play's Avatar
Mr_Play Mr_Play is offline
Noyee
 
Join Date: Oct 2005
Location: New York
Posts: 101
Mr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant futureMr_Play has a brilliant future
Re: Oracle

http://www.techonthenet.com/oracle/functions/index.php
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VB & Oracle anjaali Computing 9 December 12th, 2006 11:56 AM
Oracle:how to know which column was last modified and how? Napolean Computing 5 February 2nd, 2005 09:09 PM
Job wanted : Oracle DBA echarcha Jobs 2 March 16th, 2004 11:48 AM
Oracle 9i DBA. GpeL Jobs 1 June 25th, 2003 01:12 PM
Oracle Tuning.... ProudHindu SoapBox 21 October 16th, 2001 02:41 PM


All times are GMT -7. The time now is 06:38 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Site Copyright © eCharcha.Com 2000-2012.