I have to only get dates where the day is less than the 16th day of the month. I think its like
hire_date < day(16)
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23131697.html
Please take a look at my .profile
/**** .profile *******/
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:/usr/local/ ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23460791.html
I have a column which is called "GPname which already has some data in it.
It is a varchar, Some of it has '-' in it. For eg: H-C corporation.
I need to make it as HC corporation
Please sugg...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23773153.html
I have the following information in the control file currently.
LOAD DATA
APPEND
INTO TABLE MYTABLE
FIELDS TERMINATED B...
http://www.experts-exchange.com/Database/Oracle/Q_23778812.html
COLUMN1 COLUMN2
8983888 2
8983888 1
8983888 5
Need to sort this first
8983888 1
8983888 2
8983888 5
then I need to sequence COLUMN2
...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23783197.html
How to spool the output of an sql query into a CSV file?
select * from table1 group by column1;
And the select statement should not print anything to the System Out. How to do that?
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23783269.html
I need to write a function such that it will have an insert statement
and this function should return the number of rows inserted into the table. How to do that?
My table name is my_table and ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23785977.html
I have a requirement where
COL1 COL2
101 1
101 5
101 2
102 3
102 5
first it needs to ordered according to col1 & col2
COL1 COL2
101 1
101 2
1...
http://www.experts-exchange.com/Database/Oracle/Q_23811081.html
How to pass a variable name 'SA' into the SQL below?
create or replace
FUNCTION Func_ClaimLineFix(schema1 in VARCHAR)
RETURN VARCHAR
IS
VAR VARCHAR(10);
SQLTXT VARCHAR(1000);
BEGIN
...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23814370.html
If there is an exception in Oracle procedure, will it roll back or do i have to roll back explicitly?
create or replace PROCEDURE Proc()
IS
BEGIN
UPDATE STMT;
EXCEPTION
...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23831162.html
