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
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
Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as char(16) and placing in a new table defined as varchar2
SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum
so I'm running
select * from mytable where rownum = 1;
how to populate a drop down box
Hi buddies!
PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar)
is
begin
DOWNLOAD_REPORT_HEADER(report_name);
htp.p('
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
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
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
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
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
