max function question
Hi All
Ihave a table that holds shipment numbers and dates like this
select * from ship_tab;
ship_num date_ship
1 09-SEP-09
2
Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R2 DB on windows 2003 server. I have a batch file
Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Oracle:
decimal(decimal(A.record_count-A.generic_c
how to populate a drop down box
Hi buddies!
PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar)
is
begin
DOWNLOAD_REPORT_HEADER(report_name);
htp.p('
Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as char(16) and placing in a new table defined as varchar2
Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
If i connect to the gv$session table, i have to pass othe
Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thought I could use the ASCII function, but SELECT ASCI
please help me in this update statment
hi every one
if I have table and this data in it
id name
10 john
10 ibraham
10 edward
10 ker
help with multi-update
Now sure how to ask this really....
10g database if that matters.
I have a customer that accidently changed 742 records incorrectly. I'm being as
Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any docs is appreciated...)
All of the docs I've looke
please help me in this update statment
hi every one
if I have table and this data in it
id name
10 john
10 ibraham
10 edward
10 ker
help with multi-update
Now sure how to ask this really....
10g database if that matters.
I have a customer that accidently changed 742 records incorrectly. I'm being as
Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",
substr(I_NAME, INSTR(I_NAME,'O')+1) "Second part"
FROM Enrollment
WHE
Combining refCursors and Summing
Given the following DDL:
CREATE TABLE FOODSALESTEST
("WEEKNBR" NUMBER,
"STOREID" NUMBER NOT NULL,
"GUESTS" NUMBER NOT NULL,
"T
Problem with a select distinct
I have a problema with a select distinct, I have the next sql:
select distinct a,b,c,d from (select a,b,c,d,e,f...from table where ...)
The subs
column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lname like "'%"||p_lname||"'"
It keeps giving me syntax
Linking with Foreign Keys
I have been getting an erro when I try and link:
create table Faculty_Specialty (I_Name varchar2(20) not null, Specialty varchar2(40) not null);
Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think.
SQL> select prclid from parcel
2 where expdate = '';
no row
how make 2 column in table with data tybe long row
hi every one
I want make in my table 2 column with data tybe long raw
how this
thanks
