Edit Records In 10g EM?

Mar 26, 2009

I just loaded the 10g client EM on my Windows workstation to connect to our 10g database.Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had with 9i client OEM.Before we had 10g, I used to have the 9i OEM and it let me edit records in 9i OEM where I could add, delete and update records with a user friendly interface.

how I can edit records in 10g EM?

View 3 Replies


ADVERTISEMENT

Edit Profile On Unix (x86-32) During 1og Installation?

Sep 26, 2011

how to edit profile on unix [x86-32] during 1og oracle installation. edit /export/home/oracle/.profile

View 3 Replies View Related

Enterprise Manager :: Cannot Edit Listener

May 14, 2010

i am learning oracle technologies,i downloaded and installed 11g and log in as sys as sysdba in enterprise manager,in em certain tasks ask for password again, for example in main page when you want to edit the listener it asks for password, the problem is what kind a password does it want?, i tried os password and sys or system password but it did not work, it also happens when you try to shutdown the database,it asks for os and below it asks for another password,

View 2 Replies View Related

Application Express :: How To Use Computation With EDIT

Mar 19, 2013

I have used computation in form .i have take 7 check box item with value

MON =1
TUES =2
WED =3
THU =5
FRI =6
SAT =6
SUN =7

these item are not database column.

Using computation after submit i have concatinate it and insert in to OPERATING_DAYS Column into table.
example :if i check MON AND WED AND FRI THEN concatenate value insert into table 136

:P6_MON||:P6_TUS||:P6_WED||:P6_THR||:P6_FRI||:P6_SAT||:P6_SUNPloblem is when i edit record but this 136 value of operating days does not come into MON,WED and FRI.

How to extract these days value from OPERATING_DAYS Column into respective Days Item.

View 2 Replies View Related

Client Tools :: How To Edit Timeout For Each User

Sep 25, 2012

how can i edit the timeout for each user

i.e i need the user who didn't user forms or reports to be disconnected automatically from the oracle how can i do that

View 1 Replies View Related

Spatial :: How To Edit User Metadata View

Oct 19, 2012

how is to edit user_sdo_geom_metadata view?

View 6 Replies View Related

Application Express :: Disable Edit Link

Dec 14, 2012

i want to disable my EDIT link in report if it satisfy my case condition.

i am using some code but using this i can unable and disable text link not a image link how can i disable image link like edit link in report.

select * from (
SELECT AP.*, CASE WHEN AP.INVOICE_STATUS='C' THEN
'<font color ="Red"></b>Modify Invoice</b></font>'ELSE
'<a href="f?p=&APP_ID.:58:&SESSION.:INV_ID:&DEBUG.:58:P58_INV_ID:'
||INV_ID||':">
[code]........

View 5 Replies View Related

Forms :: 6i Requirement - Create New User And Edit Existing One

Jun 10, 2011

I have a form with fields like, UserName, User ID Email Address. This is used to create new users & edit existing user information. I wanted to make the Email field mandatory. So i made the email field as 'Required' via Proerty Pallette. So when ever i create new users after this change, i get a message saying 'Field must be required' when i try to skip this email field.

However when i edit existing user information and try to save the data with no email address i am able to save. So, where when i try to save a user info with no email address, i should get a warning saying 'email address is required'. How to go about it and if i wil have to create any trigger.

View 5 Replies View Related

Forms :: Unable To Make The Form Fields Available To Edit

Jan 30, 2013

My requirement is to call a form through special menu icon from one main form and display some information. Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit. I am displaying a record based on a view.

For that i have used below code in when-new-form-instance

- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');

After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.

I have added below piece of code

set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);

in almost all the triggers and tried. I could still see all the fields are read only.

View 4 Replies View Related

Application Express :: Interactive Report / Edit Option

Jan 28, 2013

I have created interactive report
--------------------
SELECT EMPNO,
ENAME ,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO
---------------------------------
and Report Attributes=>Link Column have given Link to custom <img src="#IMAGE_PREFIX#e2.gif" border="0"> for P9_EMPNO...the editable displaying fine.

MY Requirement was ..in the editable link...i need to control with DISBALE/ENALE with if EMPNO=100 then all 100 id records need to editable link disable and if EMPNO=120 then All 120 records editable link need to be enable..this kind of thing need in the report..

View 2 Replies View Related

Application Express :: Edit Detail On Separate Page?

Aug 26, 2012

i am try to build master and detail i use Edit detail on separate page , but when i want to create new record in detail page the master column is display and not retrieve the value .

the example in my workspace
http://41.41.94.126:8080/apex/f?p=102:10:2106214435268201::NO::::
user login : ahmed
pass : 123

workspace : spark
user : saied
pass : 123

View 6 Replies View Related

Application Express :: Edit Region Display Selector

Dec 7, 2012

Is possible to remove the "show all" of the Region Display Selector? How can i do this?

View 8 Replies View Related

Application Express :: How To Save And Edit Word Template

Aug 30, 2012

How to save and edit a Word template and excel (extension. doc and. xls), which can be opened to allow the document and record all changes made ​​by the user of the pacification.

View 0 Replies View Related

Application Express :: No Page Edit Functionality After Upgrade To 4.2.2?

Jul 12, 2013

Apex has been upgraded from 4.1 to 4.2.2. I don't know if the upgrade was done correct or not by the administrator, but I don't have the page edit link anymore,

and anytime I run a individual page from the Edit Application, I have to Log in. Did something went wrong during the upgrade or is this the behavior of Apex now, which I don't think so.

View 1 Replies View Related

Application Express :: Edit Page Fetching With Rowid

Feb 9, 2013

I have an interactive report from a view and have a rowid column that is a link to a page to edit a table.

The rowid value in db is: ABH/WVAG1AAAAF9AAA

But the generated link is:

f?p=XXX:24:9420765805297::NO::P24_ROWID:ABH%26#x2F;WVAG1AAAAF7AAA

And when it loads the page it happens a no data found error (because the escaped characters)

What would be the solution for this problem?

View 1 Replies View Related

Security :: How To Edit Created Policy (Virtual Private Database)

Mar 28, 2012

I Created the Security Policy as user sysadmin_vpd as follows

BEGIN
DBMS_RLS.ADD_POLICY (
object_schema => 'scott',
object_name => 'orders_tab',
policy_name => 'orders_policy',
function_schema => 'sysadmin_vpd',
policy_function => 'get_user_orders',
statement_types => 'select');
END;

After creation this policy I want to view & edit them.By default where they are saved.

View 3 Replies View Related

Application Express :: 4.2.3 Bug - Cascading Style Sheets Cannot Edit From List View

Oct 3, 2013

APEX Builder page 4000:37 List view shows name, notes and download columns. The name column should link through to CSS Edit page (39), but instead downloads the file. Workaround: Switch to the icon view, and click on the icon which takes you to the CSS edit page. Can the APEX team correct this, as switching to icon view is not intuitive. 

View 0 Replies View Related

Application Express :: Edit Bar And Save Report From Actions Menu Is Missing

Jun 21, 2013

We have recently did upgrade from 4.1 to 4.2 with listener 2.0. The edit bar (to edit the page) and Save Report option from Actions Menu ( Interactive Report) are missing, is it a bug?

View 3 Replies View Related

Best Way To Change Language Of Windows Oracle Client Machine Edit Registry

Jun 29, 2012

We have installed oracle client on Windows machine and despite selecting language as English

when look in registry shows NLS_LANG as

AMERICAN_AMERICA.WE8MSWIN1252.

What is the best way to change language of Windows oracle client machine edit registry.

View 2 Replies View Related

Application Express :: Error When Calling Skillbuilder Popup In Edit Record Mode?

Jan 3, 2013

Iam facing another issue with Skillbuilder modal page(for those who have used this plugins). Ive the CREATE part working well the problem is with EDIT part to edit records via the link i applied all the steps and clicking the edit link pops up the page but the issue is for any clicked row the parameter is not being passed and seleceted record doesnt show on the pop up page where could the problem be? though if i set it back to normal link created by the wizard the edit link works well and shows that record on the editable page.

Apex 4.1.1/oracle 11gR2 ; issue happens in FF & IE

View 3 Replies View Related

Forms :: User Privileges - Assign Permissions To One User To Add / Delete / Edit Data?

May 28, 2011

how can i assign permissions to one user to add,delete,edit data and other user should be able to perform all functions or selected functions

View 12 Replies View Related

Application Express :: How To Protect Oracle Application From Code Edit On Client Side Installation

Sep 12, 2013

We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,

Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.  

View 1 Replies View Related

SQL & PL/SQL :: Oracle 10g - Update Records In Target Table Based On Records Coming In From Source

Jun 1, 2010

I am trying to update records in the target table based on the records coming in from source. For instance, if the incoming record is present in the target table I would update them in the target else I would simply insert. I have over one million records in my source while my target has 46 million records. The target table is partitioned based on calendar key. I implement this whole logic using Informatica. Looking at the informatica session log I find that the informatica code is perfectly fine but its in the update part it takes long time (more than 5 days to update one million records). find the TARGET TABLE query and the UPDATE query as below.

TARGET TABLE:
CREATE TABLE OPERATIONS.DENIAL_REGRET_FACT
(
CALENDAR_KEY INTEGER NOT NULL,
DAY_TIME_KEY INTEGER NOT NULL,
SITE_KEY NUMBER NOT NULL,
RESERVATION_AGENT_KEY INTEGER NOT NULL,
LOSS_CODE VARCHAR2(30) NOT NULL,
PROP_ID VARCHAR2(5) NOT NULL,
[code].....

View 9 Replies View Related

SQL & PL/SQL :: Procedure To Delete Records / Count Number Of Records Has Been Deleted

Feb 21, 2011

I have written the following PL/SQL procedure to delete the records and count the number of records has been deleted.

CREATE OR REPLACE PROCEDURE Del_emp IS
del_records NUMBER:=0;
BEGIN
DELETE
FROM candidate c
WHERE empid in
(select c.empid
from employee e,
candidate c
where e.empid = c.empid
and e.emp_stat = 'TERMINATED'
);
[code]....

View 6 Replies View Related

SQL & PL/SQL :: Returning List Of Records That Do Not Have Associated Records From A Sub-query

Sep 6, 2010

I am running a query in our Clarity PPM database to return a list of all Support projects. This returns a simple list of project code and project name:

The query has the project resource tables associated with it, so I am able to list all resources allocated to the project. But for now i am only selecting a DISTINCT list of projects.

Query for anyone interested:

Select distinct
Project_code,
project_name
from
niku.nbi_project_current_facts nbip,
niku.odf_ca_project cst,
niku.prtask t,
[code]........

I have a separate query which returns a list of support resources.

select res.full_name, res.unique_name , dep.description
from niku.srm_resources res,
niku.pac_mnt_resources pac,
niku.departments dep
where res.unique_name = pac.resource_code
and pac.departcode = dep.departcode
and res.is_active = 1
and description like 'IMS%'
and UPPER(dep.description) like '%SUP%'

What I need to be able to do in the first query, is return only projects that do NOT have a resource that appears in the resource list in the second query.

(the res.unique_name field in the second query can be linked to the same in the first query)

Logically, the process would be:
1. Identify Support Project
2. Identify Resources allocated to the project team
3. Compare with List of Support Resources
4. If any Resources in that list do NOT appear on the project, then return project.

View 18 Replies View Related

SQL & PL/SQL :: Differences Among Records Tables And Tables Of Records

Sep 16, 2010

In Oracle database pl/sql 11.2: describe the differences between :

records,
tables, and
tables of records.

View 11 Replies View Related

SQL & PL/SQL :: How To Get Records For Max Value Only

Sep 21, 2010

I am working on the below query:-

SELECT adv_list.advisor_code advisor_code,
adv_list.available_wip, tot_score from(
SELECT advisor.advisor_code advisor_code ,
(wip.wip_limit - SUM (DECODE
(lead_status, 'F1', 1,0)))
available_wip,advisor.tot_score

[Code]...

The below query returns :-

Advisor_code Tot_Score
------------- ---------
00015946 10
00026742 10
00081276 10
00540272 5

My requirement is to get only those records that have the max(Tot_Score).

So I should get:-

Advisor_code Tot_Score
------------- ---------
00015946 10
00026742 10
00081276 10

I am trying to put MAX(TOT_SCORE) in the select list but its not giving the desied result.

I do not want to give it in the where clause as I will have to gain put the whole subquery again.

wherein I can get the MAX tot_score records only with minimum coding.

View 2 Replies View Related

SQL & PL/SQL :: Get AVG Of All Records

Sep 6, 2013

Type Specification :
CREATE OR REPLACE TYPE ArrayCounterSum AS OBJECT
(
-- AUTHOR : CLIVE.GREGORY
-- CREATED : 03-04-2010 14:44:02 14:44:02
-- Modified : S. Glass - Removed read function to increase performance

[code]...

Type Body :
TYPE BODY ArrayCounterSum AS
2
3
4
5

[code]...

So the output will be : 6_10_15_13_14 (Sum of all rows and return as an array)My Goal is to AVG the ROWS and retrun it into array. so what change should I make in above code in order to get the AVG of all records.

View 25 Replies View Related

Get Latest Records?

Jun 9, 2011

I have a table that contains history for vehicle positions. In order to find the latest positions quickly, I've included a LATEST column that is 1 if the record is the latest position and 0 otherwise. The table is maintained via a stored procedure. The procedure first sets the latest record for the vehicle to history...

UPDATE vehicle_positions SET latest = 0 WHERE vehicle_id = <vehicle ID> AND latest = 1

It then inserts the new latest record...

INSERT INTO vehicle_positions (vehicle_id, longitude, latitude, insert_time, latest) VALUES (<vehicle_id>, <x pos>, <y pos>, SYSDATE, 1)

Is it possible for me to end up with 2 latest records?Consider this scenario...

Session #1: UPDATE vehicle_positions SET latest = 0 WHERE vehicle_id = 123 AND latest = 1
Session #2: UPDATE vehicle_positions SET latest = 0 WHERE vehicle_id = 123 AND latest = 1
Session #1: INSERT INTO vehicle_positions (vehicle_id, longitude, latitude, insert_time, latest) VALUES (123, 32.8533, -117.1180, SYSDATE, 1)
Session #2: INSERT INTO vehicle_positions (vehicle_id, longitude, latitude, insert_time, latest) VALUES (123, 32.8534, -117.1178, SYSDATE, 1)

I'd end up with 2 latest records. How can I protect against this? I considered using SELECT FOR UPDATE, but seems like there are too many negatives going that route

View 4 Replies View Related

Fetching Last N Records?

Jun 5, 2012

oracle version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

CREATE TABLE MACHINE_M (
IDVARCHAR(20)NOT NULL,
NAMEVARCHAR(20)
)

[Code]....

Now when there records in READING_DWR are 1 lakh, i am getting the o/p in 10 sec.
However when there are bulk records, it is taking 3 to 4 min.

Is there any way to improve my query performance?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved