Search results for query: *

I am working on an application that is hosted on same DB server as another application. We share this server with this another app, but we are under different schemas. We have a need of RO access a table or materialized view or view under the schema of this another application. What would the...

I have this piece of code. public class Q { static int x = 11; private int y = 33; public static void main(String args[]) { Q q = new Q(); q.call(5, 555555); System.out.println("Value of x " + q.x); System.out.println("Value of y " + q.y); } public void call(int x, int y)...

I have a script (find_keyword.ksh) that reads data from a txt (keyword.txt) file and produces results if any word in txt files matches in the directory containing files that end with .ksh I pass directory path at the time of script execution. I am facing two issue that I would like some tips...

NEWBIE to ORACLE SQL and I have a following situation: Table X_1 (PRIMARY KEY A_1) A_1,A_2,A_3,A_4 8998A,01/01/2014,XYXY,REST WELL BHYXTY,04/20/2015,UUUU,PEACE 99999,02/06/2014,LLLL,FUN TABLE X_2 (F_1 & F_2 PRIMARY KEY) F_1,F_2,F_3,F_4,A_2,A_3,A_4 8998A,0,TEST,XXX,NULL,XYXY,NULL...

Hi, I would like to remove all the lines in a file that contains letters (upper case) KJ at postions 6-7 from the begging on line. an example would be: 1ABNPKJLDS9PORT_SIL 200708800 copu 1PORPKJLDUS9PORT_UYT 200700000 KLPU 1ABTPKJLDS9JOB_SIL 200708800 CPOI 1POIPKJLDUS9PO_UYT...

I have a one long list of alphanumeric data approx. 3000 some rows in EXCEL 2010. Following is an example: PP5690 AG8908 KJ3459 EVENTHORIZON LISTnumber UI3409 IL0965 I want to remove all rows that DO NOT conform to value like PP5690 i.e. First two characters are alpha and next four are...

We are using Sun server and teradata database. There is a need to upgrade teradata version, but lot of data load is done via ksh scripts, which has embedded SQL in it. Well, Teradata has some words that are reserved words in this new version. Is there a way to write a script (using awk or...

Following are my objects. Problem desc is at the bottom of my post. I am close, but need little help at the end. CREATE SEQUENCE P_TEXTBODYID START WITH 360000 MAXVALUE 999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TABLE TEXTBODY_TMP ( TEXTBODY_ID...

I would like to create a Oracle FUNCTION that will return unique listings of location types once a site_id is passed to it with carriage return as a separator (char13) I took a first crack at the code, but I don't know how to handle multi row return. As it would happen in this case. CREATE...

I have a directory and following are its contents: /ppp/ndm/ndm_ari drwxr-xr-x WEB-INF -rw-r--r-- about.jsp -rw-r--r-- index.jsp -rw-r--r-- help_docs.jsp Can someone please explain to what this expression will result in: ^/(.*)$ /ppp/ndm/ndm_ari/$1 I am assuming...

I have been researching this for last few weeks and now hit a brick wall. May be someone here can shed some light on this. I want to know if this is even possible? Background: I have apache as http and tomcat as servlet container using mod_jk. They are running a java app on Solaris 10. Issue...

I have installed apache 2.2.23 using following instructions: $ gzip -d httpd-NN.tar.gz $ tar xvf httpd-NN.tar $ cd httpd-NN Configure $ ./configure --prefix=PREFIX Compile $ make Install $ make install Customize $ vi PREFIX/conf/httpd.conf Test $ PREFIX/bin/apachectl -k start Apache...

Guys, I am trying to install Apache httpd 2.2.23 on Solaris 5.10. So, far it has been a disaster. Here is my issue. I do everything by the book and follow the steps. ./configure --prefix=/appl/newapp/apache2 All goes well. But all the hell breaks loose when I use make command. Here is small...

I am trying to improve an existing website for a non-profit (free job) that has used tables for everything in it and behaves different on different browsers. My goal is to use CSS for formatting and use to DIV elements to position every section on the page. I am new to CSS and use of DIV...

This question is for all Unix gurus out there. I know that for password less sftp to work home directory should have go-w ex: /user/home/europa drwx--x--x 7 europa saturn 512 Mar 12 10:30 . This is a SUN Solaris machine 5.10: I want to use ACLs to allow another user:mars that is...

I am in a odd situation. Following is my query running against the dataset as show below: Select name from table_name where (send_yn='Y' or send_yn='N') and (last_change_dt = sysdate -1) and (last_change_dt > sent_system_dt OR sent_system_dt is null) Users via front end manipulates send_yn (by...

I am in a odd situation. Following is my query running against the dataset as show below: Select name from table_name where (send_yn='Y' or send_yn='N') and (last_chnage_dt = date -1) and (last_change_dt > sent_system_dt OR sent_system_dt is null) Users via front end manipulates send_yn (by...

Guys, I have successfully coded the shell script output to a logfile: LOG_DIR = /xxx/yyy exec 1>$LOG_DIR/script_name/$(date +%Y%m%d%H%M).log This script performs several functions. Mainly inserting data into several Oracle tables. This takes time. I want to see these two things happen. A or...

Guys, I am a newbie to shell scripting. I am dealing with an issue of a process being hung on a random basis for days. Is there a way to write a script that will send an email (with process or job details) if a process has been running for more than 24 hrs? I use cron to run different jobs. I...

CREATE TABLE TEST4 ( ITEM VARCHAR2 (12), JOBNUM VARCHAR2 (12), GENERIC VARCHAR2 (20), TERM_EQUIP_GROUP_ID VARCHAR2 (20), PRIMARY KEY (ITEM, JOBNUM) ); INSERT INTO TEST4 VALUES ('AAAA1', 'XXXX1', '1AE12.05', '1AE'); INSERT INTO TEST4 VALUES...