I'm using a third-party backup software to backup an Oracle 10g database. The software utilizes RMAN to create the backup of the databases.The backup software appears to be configured correctl...
I have a query that pulls counts the number of picks per Customer ID per Zone per 8 hour shift which I total at the end of the report. I would like to keep the results the query returns but I...
i have a dump file.i dont want one table to be imported into the schema.how to do that?
ORA-01996: GRANT failed: password file is full.
We have to create multiple user accounts with SYSDBA system privilege. All the existing users
and the new users must have the SYSDBA privil...
Is there a query that will tell you when a tablespace or a datafile was created?
select * from dba_data_files doesn't have it.
I have an insert statement that I need to insert to a table. That statement contains '5¢'. I used single quote or double quotes to try to insert the ¢ symbol to the table but the result is '...
I have a pl/sql code that I need to understand. Does this mean that second query "v_sql" has already been limited to the region (r.region_code) 'BUS' from the first query?
IF UPPER(r.regi...
One EMPLOYEE can have multiple EMPLOYEE_PACKS.each pack must have one or more items.
if you see data below for 1st employee 4 packs are there and for 3rd and 6th packs doesn't have items in...
We have two tables
1)
Plm ( PlmNo is the primary key)
which contains the following rows:
PlmNo AdDate Type StDate
101 111 somedate
102 131 somedat...
Hi experts, I need help to show the balance. It should show in order of dates and by different company codes.
My table has columns
-Code
-Payment_date
-Description
-Debit
-Credit
...
Hi,
I have the following insert statement.
Don't know why, it can't read the phone number?
SQL> SQL> 2 INSERT INTO STUDENT VALUES (STU_1,'OMEGA', 'SUKI', 'SU_OMEGA@URCOMPANY.COM', ...
What is Oracle Stream?
how to work with?
How to use it?
Where it will be used?
I can select from a table
but when I try to add a column to it
it said table or view does not exist, why?
There is one table with 4Million rows, running one query is causing performance issue.
Please help on how to resolve it.
SQL> select count(*) from psp.psp_adjustment_lines_history
2 /
...
I am having trouble running the follwoing query after an Oracle(10G) upgrade:
The dev database was upgraded and not production. I can run this is production and I get rows. When I run it ...
Hi
below is the loop with dynamic sql used for inserting data into remote database.
when I try to exceute the proc it is executed with errors but it is not inserted into remote database ta...
I have a table structure like this ;
I want to retrieve the employee which is having same country as employee '1'.
in the final resultset only 2nd employee should come.
Hello,
How can I connect to a remote database (say via sqlplus) and run a DOS command on the remote system?
I was experimenting with the host and bang (!) commands but they seem to only ...
i have a table in oracle that has at least 20 columns. i would like to get column headers/names into excel. is there a way to do that operation?
HI Experts,
When i try to access one of the table in the database.
i am getting the following error
ORA-24365 error in character conversion.
Could you please help me on this?
I have a cursor (variable varchar2) that processes the variable in it's where clause.
It works fine with a single string variable but does not when give an concatenated string.
Cursor D...
Setup:
TableA (data table)
Column1: caseid
Column 2-20: stuff
Example TableA:
Bob Old 54yrs
Mike Old 32yrs
Jon ...
In a select statement there is where clause I haven't seen before.
"Where l.licensenbr = p.license (+) and l.state = p.state(+)"
What does the "(+)" do?
Thanks
Ron
i have non database field (hours and mints) like 44.5 and i want to convert it to time like 44:30 , how can i do that ?.
I know that i have to use the CONCAT. function to achieve dr joze from joze in the same column. How ever I have three tables to change and I need to do it with one query/subquery/correlated qu...
