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, so instead of going through the GUI to input each number, I'm hoping to create a query to run against the (Oracle) DB and extract the information.
For instance, I have a ticket number 123456, I need to lookup the ticket number and pull user information (dept, email, phone, ect).
Help me get started with this please.
---------- Post updated at 07:19 AM ---------- Previous update was at 07:14 AM ----------
Perhaps something like this would work.
The only question I have from this is, how to get the query to cycle through a list of ticket numbers?
Hello again... I have a request from another department to list for them all the columns and tables we use in this certain database. I have spooled the oracle stored procedured into 1 file. I need a way to write out parts of that file. The criteria is to to start the block to be written when... (0 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 new to using pl/sql on a unix platform and am having trouble writing to a file from within a block. Below is an example of the code that I have. I know that I need to use UTL_FILE to accomplish this; however, I keep getting errors. Can someone please help me?
I am trying to create a... (1 Reply)
Hi All,
Please help me writing the below script.
I have two sql queries.
1. Select count(1),Client_id from TABLE_A group by Client_id;
2. Select count(1),Client_id from TABLE_B group by Client_id;
I need the output of above two sql queries in a single file. The output 2nd query should be... (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)
I'm having problems with writing my sql results to a file:
sqlplus -S username/password@DB <<!!
set echo off
set verify off
set showmode off
set feedback off
set timing off
set linesize 250
set wrap off
set pagesize 0
set newpage none
set tab off
set trimspool on
set colsep... (1 Reply)
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)
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)
Hi All ,
I have tried many times am getting syntax error on 'UNION'
can anybody tell me ...
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 (1 Reply)
Please advice to rectify below error
#!/bin/ksh
X=$(sqlplus -s user/pass << EOSQL
set serveroutput on;
set heading off feedback off serveroutput on trimout on pagesize 0
INSERT INTO TEST(df)
VALUES('a');
COMMIT;
EXIT;
EOSQL)
echo $X
echo $?
ERROR at line 2: ORA-00984: column not... (1 Reply)
Discussion started by: mirwasim
1 Replies
LEARN ABOUT MOJAVE
klist
KLIST(1) BSD General Commands Manual KLIST(1)NAME
klist -- list Kerberos credentials
SYNOPSIS
klist [-c cache | --cache=cache] [-s | -t | --test] [-T | --tokens] [-5 | --v5] [-v | --verbose] [-l | --list-caches] [-f] [--version]
[--help]
DESCRIPTION
klist reads and displays the current tickets in the credential cache (also known as the ticket file).
Options supported:
-c cache, --cache=cache
credential cache to list
-s, -t, --test
Test for there being an active and valid TGT for the local realm of the user in the credential cache.
-T, --tokens
display AFS tokens
-5, --v5
display v5 cred cache (this is the default)
-f Include ticket flags in short form, each character stands for a specific flag, as follows:
F forwardable
f forwarded
P proxiable
p proxied
D postdate-able
d postdated
R renewable
I initial
i invalid
A pre-authenticated
H hardware authenticated
This information is also output with the --verbose option, but in a more verbose way.
-v, --verbose
Verbose output. Include all possible information:
Server
the principal the ticket is for
Ticket etype
the encryption type used in the ticket, followed by the key version of the ticket, if it is available
Session key
the encryption type of the session key, if it's different from the encryption type of the ticket
Auth time
the time the authentication exchange took place
Start time
the time that this ticket is valid from (only printed if it's different from the auth time)
End time
when the ticket expires, if it has already expired this is also noted
Renew till
the maximum possible end time of any ticket derived from this one
Ticket flags
the flags set on the ticket
Addresses
the set of addresses from which this ticket is valid
-l, --list-caches
List the credential caches for the current users, not all cache types supports listing multiple caches.
SEE ALSO kdestroy(1), kinit(1)HEIMDAL October 6, 2005 HEIMDAL