Home » SQL & PL/SQL » SQL & PL/SQL » for real time information.
for real time information. [message #248822] Mon, 02 July 2007 03:42 Go to next message
abdul_rafeekh
Messages: 3
Registered: December 2006
Location: hyderabad
Junior Member

could anybody tell me 'when' and 'how' we will use functions (row,number,date,nvl.. functions),group functions,subqueries in realtime projects.
Re: for real time information. [message #248823 is a reply to message #248822] Mon, 02 July 2007 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Every time it is needed in the correct way to use it.

Regards
Michel

[Updated on: Mon, 02 July 2007 03:49]

Report message to a moderator

Re: for real time information. [message #248824 is a reply to message #248823] Mon, 02 July 2007 04:12 Go to previous messageGo to next message
abdul_rafeekh
Messages: 3
Registered: December 2006
Location: hyderabad
Junior Member

i need atleast with one example
Re: for real time information. [message #248826 is a reply to message #248824] Mon, 02 July 2007 04:14 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, here is ONE example, as ordered :

select nvl(estd_val,0) from link_tab;

Re: for real time information. [message #248827 is a reply to message #248826] Mon, 02 July 2007 04:16 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ThomasG wrote on Mon, 02 July 2007 11:14
Well, here is ONE example, as ordered :

select nvl(estd_val,0) from link_tab;



hehe.

but that one is not in MY realtime project...
Previous Topic: Performance issue OUT parameter
Next Topic: inserting values into tables
Goto Forum:
  


Current Time: Sun Dec 11 02:37:52 CST 2016

Total time taken to generate the page: 0.11425 seconds