Oracle

max function question

Hi All

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 that calls an SQL file, which runs fine when I

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:

how to populate a drop down box

Hi buddies!

SQL query not working well

Hi,

Data storage spaces in varchar2

Trying to understand what's happening.

Find current logon time

Hi,

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 ASCII('é') FROM DUAL in Oracle gives me 50089.

please help me in this update statment

hi every one

help with multi-update

Now sure how to ask this really....

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...)

please help me in this update statment

hi every one

help with multi-update

Now sure how to ask this really....

Splitting Attributes

SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

Combining refCursors and Summing

Given the following DDL:

Problem with a select distinct

I have a problema with a select distinct, I have the next sql:

column name cancatenation within PL/SQL

I have a PLSQL store procedure, and the following statement is part of a subquery

Linking with Foreign Keys

I have been getting an erro when I try and link:

Selecting an "empty" date formated field

How do you select an "empty" date field? I've tried the few ways I can think.

how make 2 column in table with data tybe long row

hi every one