Poet, Singer, Writer, Admin of Indyaspeak.com
Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as c
Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<
Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug
please help me in this update statment
hi every one
if I have table and this data in it
id name
10
help with multi-update
Now sure how to ask this really....
10g database if that matters.
I have a customer
max function question
Hi All
Ihave a table that holds shipment numbers and dates like this
select * from
please help me in this update statment
hi every one
if I have table and this data in it
id name
10
help with multi-update
Now sure how to ask this really....
10g database if that matters.
I have a customer
Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",
substr(I_NAME, IN
Combining refCursors and Summing
Given the following DDL:
CREATE TABLE FOODSALESTEST
("WEEKNBR" NUMBER,
"ST
Problem with a select distinct
I have a problema with a select distinct, I have the next sql:
select distinct a,b,c,d fr
column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lnam
Linking with Foreign Keys
I have been getting an erro when I try and link:
create table Faculty_Specialty (I_Name v
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
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 thi
records between 2 dates
Hello all,
I have a date tracked table which contains effective_start_date and effective
HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need t
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...
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 t
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...
