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....
max function question
Hi All
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
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,