oracleProblem with a select distinct
I have a problema with a select distinct, I have the next sql:
help with multi-update
Now sure how to ask this really....
Data storage spaces in varchar2
Trying to understand what's happening.
SQL query not working well
Hi,
how to populate a drop down box
Hi buddies!
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:
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
Find current logon time
Hi,
Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",
Combining refCursors and Summing
Given the following DDL:
help with multi-update
Now sure how to ask this really....
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
records between 2 dates
Hello all,
HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels.
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
