I HAVE A TABLE NAMED: EMP
TWO COLUMNS: ENAME AND 1RST_OCCUR.
I MUST FIND THE FIRST OCCURRENCE OF 'L' IN ENAME AND CHANGE IT TO 'X'.
SAMPLE:
ENAME 1RST_OCCUR
-------- ...
http://www.experts-exchange.com/Database/Oracle/Q_20781479.html
Zones:
OracleDate Answered: 10/31/2003 Grade: B Views: 20
I am creating a view in SQL PLUS. The view is using many table. I want to use a create a calculated field based 2 dates fields (one of which is displayed in the view and one that is not).
Righ...
http://www.experts-exchange.com/Database/Oracle/Q_23112183.html
Zones:
OracleDate Answered: 03/01/2008 Grade: A Views: 335
I'm doing a small database migration.
I use a staging table to put temporary data before putting it in the new databse.
I've look at it the whole day. THe WHERE condition is wrong :(
select ...
http://www.experts-exchange.com/Database/Oracle/Q_23236809.html
Hi,
I have 2 tables A and B.
A has email addresses (example: abc@infinata.com) and B has domain names (example: infinata.com)
I want to find out a sql query that would remove all email addre...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23257375.html
Dear experts,
I am using the following statement to update the table QIASA.TARGETS_TBL:
UPDATE QIASA.TARGETS_TBL
SET TARGETS_VALUE = '0.01'
WHERE TARGETSDATE = '20071231'
AND KPI = 'ARANK'...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23416252.html
I am working with a Helpdesk Software. I was asked to create a report that lists agents' comments for each ticket. Actions can be performed on each ticket and an action description providing detail...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_23446325.html
How do I do a query on a date range based on the system date.
I need to have the date(s) fall between 120 - 180 days of the system date.
I also need page breaks for each new mfg and the total cou...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23611450.html
Zones:
Oracle 10.xDate Answered: 07/31/2008 Grade: A Views: 68
Hi All,
I have a column which says FID'S & CO. How can i insert this column using sql plus.
if i say: insert into phs_itest values ('FID'S & CO'), it gives an error. so what i did is:
in...
http://www.experts-exchange.com/Database/Oracle/Q_22129302.html
Zones:
OracleDate Answered: 01/20/2007 Grade: A Views: 22
I am using SQL Plus to run my SQL commands, and I was wondering is there any way to make it so that when i run a command over several lines i can go back up a line to correct an error?
For examp...
http://www.experts-exchange.com/Database/Oracle/Q_22751038.html
Zones:
OracleDate Answered: 08/10/2007 Grade: A Views: 70
I'm trying to run a command file via SQL*plus from the command line - it almost works seamlessly but when sql*Plus loads it sits and waits - if I then press enter it executes the commands in the co...
http://www.experts-exchange.com/Database/Oracle/Q_23158532.html
Zones:
OracleDate Answered: 02/28/2008 Grade: A Views: 34
