Hi All ,
I have tried many times am getting syntax error on 'UNION'
can anybody tell me ...
Code:
INSERT INTO table1
(
Type
, num_items
, num_letters
, total_value
)
(select
type='1',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2
where
num_items = 1
group by
num_items)
UNION
( select
type='2',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2
where
num_items = 2
group by
num_items)
UNION
( select
type='3',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2
where
num_items = 3
group by
num_items) ;
Moderator's Comments:
Code tags for code please.
Last edited by Corona688; 07-31-2012 at 11:22 AM..
In
unload to
"/usr/home/data.012202"
I wish to use a date variable as in
unload to
"/usr/home/data.`date`" for the file
is that possible in a query to do, or will i need to add a mv command after the query to do it.
I tried backquotes, , and () on `date` but didn't seem to work
Thanks... (2 Replies)
I have a script that looks for all jobs that contain a particular calendar.
Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?
I have tried:
select job_name from job where run_calendar='1&15dom'
select job_name from job... (3 Replies)
Hi ...
I am doing a switch user and then rsh and then running a sql query .
I am successfull in rsh and logging into the database , but my query doesnt run ..
Here's the command :
su - linus -c "rsh -l linus psmf ORACLE_SID=SMP;export ORACLE_SID;sqlplus... (1 Reply)
Hello Everyone,
I am looking to write a script that will run on many machines in a network at the same time. They need to write a result to a common location. I plan to use a SQLlite database as this common writing point. But the concern I have is how SQLlite will react to multiple writes that... (1 Reply)
Hi,
I am passing an argument for the script and that argument values should exist in database.
bill_period_input="'""$1""'"
bill_period=`sqlplus uname/pwd@dbname <<eof!
set verify off
set heading off
set feedback off
select bill_period from bill_period_ref where... (4 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Hi Everyone,
Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below
my file contains below data
R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20|
R1|Array/Network Resistor... (9 Replies)
I used the following code
code
select * from tablename where columnname
Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem?
Thanks
Ananth (2 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hello All,
I hope I'm posting this in the right section.
I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Discussion started by: bbbngowc
8 Replies
LEARN ABOUT CENTOS
xcb_randr_get_output_property_data
xcb_randr_get_output_property(3) XCB Requests xcb_randr_get_output_property(3)NAME
xcb_randr_get_output_property -
SYNOPSIS
#include <xcb/randr.h>
Request function
xcb_randr_get_output_property_cookie_t xcb_randr_get_output_property(xcb_connection_t *conn, xcb_randr_output_t output,
xcb_atom_t property, xcb_atom_t type, uint32_t long_offset, uint32_t long_length, uint8_t _delete, uint8_t pending);
Reply datastructure
typedef struct xcb_randr_get_output_property_reply_t {
uint8_t response_type;
uint8_t format;
uint16_t sequence;
uint32_t length;
xcb_atom_t type;
uint32_t bytes_after;
uint32_t num_items;
uint8_t pad0[12];
} xcb_randr_get_output_property_reply_t;
Reply function
xcb_randr_get_output_property_reply_t *xcb_randr_get_output_property_reply(xcb_connection_t *conn,
xcb_randr_get_output_property_cookie_t cookie, xcb_generic_error_t **e);
Reply accessors
uint8_t *xcb_randr_get_output_property_data(const xcb_randr_get_output_property_request_t *reply);
int xcb_randr_get_output_property_data_length(const xcb_randr_get_output_property_reply_t *reply);
xcb_generic_iterator_t xcb_randr_get_output_property_data_end(const xcb_randr_get_output_property_reply_t *reply);
REQUEST ARGUMENTS
conn The XCB connection to X11.
output TODO: NOT YET DOCUMENTED.
property TODO: NOT YET DOCUMENTED.
type TODO: NOT YET DOCUMENTED.
long_offset
TODO: NOT YET DOCUMENTED.
long_length
TODO: NOT YET DOCUMENTED.
_delete TODO: NOT YET DOCUMENTED.
pending TODO: NOT YET DOCUMENTED.
REPLY FIELDS
response_type
The type of this reply, in this case XCB_RANDR_GET_OUTPUT_PROPERTY. This field is also present in the xcb_generic_reply_t and can
be used to tell replies apart from each other.
sequence The sequence number of the last request processed by the X11 server.
length The length of the reply, in words (a word is 4 bytes).
format TODO: NOT YET DOCUMENTED.
type TODO: NOT YET DOCUMENTED.
bytes_after
TODO: NOT YET DOCUMENTED.
num_items TODO: NOT YET DOCUMENTED.
DESCRIPTION RETURN VALUE
Returns an xcb_randr_get_output_property_cookie_t. Errors have to be handled when calling the reply function xcb_randr_get_output_proper-
ty_reply.
If you want to handle errors in the event loop instead, use xcb_randr_get_output_property_unchecked. See xcb-requests(3) for details.
ERRORS
This request does never generate any errors.
SEE ALSO AUTHOR
Generated from randr.xml. Contact xcb@lists.freedesktop.org for corrections and improvements.
XCB 2014-06-10 xcb_randr_get_output_property(3)
07-31-2012
Getting error in sql query
