Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Query to See Functions

This is a discussion on Query to See Functions within the SQL forums, part of the Databases category; What is the query or table using which I can list the predefined functions. Instead of researching book I thought if there is a query I can see the list ...

Geeks Talk > Databases > SQL Query to See Functions

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-29-2006

joel Contributing Member   Join Date: May 2006 Posts: 73 Thanks: 0 Thanked 4 Times in 4 Posts

Query to See Functions What is the query or table using which I can list the predefined functions. Instead of researching book I thought if there is a query I can see the list and try using each.

Sponsored Links

#2 (permalink)   10-02-2006

parthokonar1 Junior Member   Join Date: Oct 2006 Location: india Posts: 19 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to See Functions I dont think it can be done through sql query, but it can be done through java jdbc programming which can extract all the predefined functions and display them

#3 (permalink)   10-13-2006

joel Contributing Member   Join Date: May 2006 Posts: 73 Thanks: 0 Thanked 4 Times in 4 Posts

Re: Query to See Functions Thanks parthokonar1. I have tried programming as per your suggestion and could get the details.

#4 (permalink)   02-23-2007

andatta123 Junior Member   Join Date: Feb 2007 Location: New Delhi Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to See Functions select * from sysobjects where xtype like '%FN%'

Geeks Talk > Databases > SQL

« SQL Injection Attacks | LOBs »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ways to Achieve Query Optimization	joel	SQL	2	02-07-2007 02:19 PM
Performance Query	blenda	Database General	3	12-27-2006 07:56 AM
Adding functions to function generator	bvani	WinRunner	2	12-20-2006 04:56 AM
Help me know about this term Flashback Query	norman	SQL	1	06-24-2006 10:21 PM
where to write sql query at runtime	dssanjay	WinRunner	1	06-03-2006 08:02 AM

All times are GMT -4. The time now is 01:29 AM.