Search Results

Search found 5 results on 1 pages for 'randeepsp'.

Page 1/1 | 1 

• formatting the output of a sql query.

  - by randeepsp

  Hi! I am using solaris os. from solaris im logging into sql plus. my database is oracle 9i. i am spooling the output of my query into a file. i want in .csv format so that i can copy it into excel. can any1 help me out. my query is like. select name,id,location from employee;

  Read the article

• how to combine the related version in group by

  - by randeepsp

  select count(a),b,c from APPLE join MANGO on (APPLE.link=MANGO.link) join ORANGE on (APPLE.link=ORANGE.link) where id='camel' group by b,c; the column b gives values like 1.0 1.0,R 1.0,B 2.0 2.0,B 2.0,R 3.0,C 3.0,R is there a way to modify the above quer so that all 1.0 and 1.0,R and 1.0,B are merged as 1.0 and 2.0,2.0,B are merged as 2.0…

  Read the article

• i want to copy the output of unix and sqlplus into a file .

  - by randeepsp

  I am using Solaris. I have to log into sql plus and run some queries, which give a huge result set. I want to copy all that into a file. Is there any command for it in unix or sqlplus ?

  Read the article

• need to read data from oracle database with many conditions

  - by randeepsp

  hi! i have 3 tables A,B and C. table A has column employee_name,id table B is the main table and has columns id,os version. table c has the columns id,package id and package version. i want to query the count of employee_name where the id of table a and c are matched with id of table b(which is the main table). i should also get the names of…

  Read the article

• can any1 tell me what -a in unix means.plz see the following code

  - by randeepsp

  can any1 tell me what -a in unix means.plz see the following code: if [ "$x" = "$x" -a "y" -eq 0 ] ; then echo $x else echo $y

  Read the article

1