comp.lang.idl-pvwave archive: archive » problem with idl database

Home » Public Forums » archive » problem with idl database

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: problem with idl database [message #53959 is a reply to message #53787]

Thu, 10 May 2007 15:49

Rick Towler
Messages: 821
Registered: August 1998

Senior Member

> Can you tell me more detail about View?? I never use it before. i
> fill happy if you can give me some examples.

No, but a lot of other people can. Try this for starters:

http://odetocode.com/Articles/299.aspx

You'll need to use the "AS" clause in your SELECT to rename your
columns. Something like:

CREATE OR REPLACE VIEW myIDLDataminerTable AS
SELECT
columnOne AS colOne,
funkyName AS notFunkyName,
columnThree AS colThree
FROM myFunkyTable;

You will need privileges on the database to create a view so you may
have to ask your DBA to do this. Once created, anyone with select
privileges will be able to query it.

-Rick

Report message to a moderator

[Message index]

		problem with idl database By: stin.wang on Fri, 27 April 2007 19:55
		Re: problem with idl database By: Rick Towler on Thu, 10 May 2007 15:49
		Re: problem with idl database By: stin.wang on Thu, 10 May 2007 02:48

Previous Topic:	MODIS43: Question on processing albedo lookup table...
Next Topic:	How to print 100 in exponential format as '10^2'

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 11 23:19:51 PDT 2025

Total time taken to generate the page: 1.27884 seconds