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
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
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
records between 2 dates
Hello all,
I have a date tracked table which contains effective_start_date and effective_end_date fields where we have the start date and end date
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 to use DBMS_SQL in order to execute them.
In theese SQ
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...
But the in view DBA_AUDIT_TRAIL,I was getting empty
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.
I know I can update 1 with
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...
But the in view DBA_AUDIT_TRAIL,I was getting empty