SQL & PL/SQL :: How To Hide The Table Data

Jan 25, 2012

how to hide the table data in oracle

View 2 Replies


ADVERTISEMENT

Forms :: Hide The Data Input When Entered For Security Purposes?

Jan 23, 2013

i have a field referring to a password and i need to hide the data input when entered for security purposes.

example if the user enters 1111 the form displays ****

View 3 Replies View Related

SQL & PL/SQL :: Hide A Column In Select Clause?

Aug 11, 2011

I need to know if it is possible to hide one or more of the columns in my SELECT statement as I only need them in there where clause.

View 6 Replies View Related

Security :: How To Hide Password In Script

Feb 6, 2011

I have following problem I have simple script in bash where I connect to db and launch simple select.

username:$(value)@host...

Problem is that i want to hide the password or encrypt. currently as you can see Iam using variable (value) where the password is keep. the problem is that, mentioned script is launched by many people which are using the same user (monitor). the variable is read from a file where user (monitor ) has access its in the same directory.

is there any way how to solve it ?

for e.g.
1. to put the file with password in another folder where the user (monitor) has no access to see the file.
2. to decrypt the password, but I have no clue how to do it .

View 23 Replies View Related

Forms :: How To Hide A Button While Runtime

Mar 30, 2012

We have a Form for viewing some datas, now i need to create a new button and Hide that button while run time for All Users except one user, how to set this option.

Addl.info: This Button should be displayed only for a single user login not for all the users using that form. how to make this option?

View 2 Replies View Related

Forms :: Hide Username And Password?

Mar 21, 2011

I already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:

sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1

So when i run this show me the message:

File 'c: este.rdf=%' not found.

It's showing a '=' sign

View 1 Replies View Related

Forms :: How To Hide Stacked Canvas

Jan 31, 2012

I'd like to hide my stacked canvas. This is my scenario, i have my content and stacked canvas on the same window. When i click a button on the content canvas it will display the stacked canvas, this is the code that i used:

SHOW_VIEW('CV_STACKED');

And on my stacked canvas, i put a button close and fired a when-button-pressed trigger,

HIDE_VIEW('CV_STACKED')

supposedly, it should hide the stacked canvas, but it doesn't hide. i tried SET_VIEW_PROPERTY('CV_STACKED', VISIBLE, PROPERTY_FALSE)

View 8 Replies View Related

Forms :: How To Hide Text Prompt

Jul 27, 2011

I have created a text prompt in layout editor by clicking a button 'TEXT'('A' symbol) from left hand side toolbar,text is created with name 'TEXT67' and graphics type 'TEXT'.

when i click that text(TEXT67),block showing <null>.

So i cant use the below code,bcoz no block for that text..

SET_ITEM_PROPERTY('<BLOCK_NAME>.<TEXT_NAME>',PROMPT_TEXT,' ');

then i tried below,i.e i skip block name i gave only text name..

SET_ITEM_PROPERTY('TEXT67',PROMPT_TEXT,' ');

not working...

View 2 Replies View Related

Forms :: How To Hide Port From Link

May 4, 2010

how to to hide the port number from the linkof my oracle web application???I call my application through a url like:[URL]...

how can I customize this url??

View 1 Replies View Related

Forms :: How To Hide MENU And TOOL Bar

Jun 22, 2012

i want hide the content shown in the picture

View 6 Replies View Related

Forms :: Hide User Name And Password?

May 4, 2010

when i want to call report from form how i can hide user name and password from the link in 10g ??

View 1 Replies View Related

Forms :: How To Hide Pause Message

Jul 20, 2010

I need to hid the PAUSE Message "Please acknowledge". when I use PAUSE key word and replace it with another message

View 1 Replies View Related

Application Express :: Tab Hide And Show According To User?

Dec 26, 2012

i want to hide/Show tab according to application user.i want to display tab abc if application user exist in group 006 .

My Column Name in user table name :user_master

{
user_id varchar2(15),
grp_id varchar2(10)
}

what sql statement i apply to hide and show Tab.

View 1 Replies View Related

Application Express :: Hide / Display Tabs?

Jun 13, 2012

In my application, I have SSO authentication. However, I also want to restrict access to certain pages (tabs). What would be the best approach for this? Secondly, How can we hide/display tabs in the application?

I am on 4.1/11g

View 5 Replies View Related

Reports & Discoverer :: To Hide The Username And Password

Dec 20, 2010

I migrated the report from Developer 2000. This report has the drill down report with the following command.

procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;

After Migration into Oracle Application Server 10g release 2 , I changed the code as following:

function U_1FormatTrigger return boolean is
begin

SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem

When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.

I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".

View 5 Replies View Related

Forms :: Hide Menu Bar And Tool Bar Of Browser At Run Time?

Mar 30, 2011

i want to hide browsers menu bar and tool bar at form run time and i want to show only form menu in the browser

View 2 Replies View Related

SQL & PL/SQL :: Hide Declaration Or Declare It Inside The Body Of Package

Mar 11, 2010

I have a package which has couple of Procedures and functions. I use some constants between the functions and procedure and also functions r called from the other procedure and stuff...

So I declared all these in the header

Like this

CREATE OR REPLACE PACKAGE "PROCESS_HISTORY" IS
type table_name_i is varray(100) of VARCHAR2(30);
c_add constant number := 1;
c_del constant number := 2;
c_select_frm_tmp constant number := 1;
[code]......

Now is there anyway I could hide the stuff that I don't want outside people to see? or can I declare them (constants and some functions) some where inside the body and use them?

View 9 Replies View Related

SQL & PL/SQL :: Encrypt / Hide Password In Create DB Link Script

Sep 14, 2010

I have a script that creates all db links for a schema. The script currently has hardcoded password use to create db link. We do not want to hardcoded password in the script.

I am planning to manually ask to input the password using accept command in sqlplus but this may be time consuming because there are many db links. So, I wanted to know if there are any better options ? Is there any way to use encrypted password in the sql file?

View 6 Replies View Related

Application Express :: How To Hide Column Link URL On Status Bar

May 8, 2013

Apex 4.1

I have IR wit one column link target to URL, and it uses javascript:my_function(#COLUMN_VALUE#)as URL, that is, calls some function and passes the value of that column to the function; everything works fine; but when I place a cursor over the link, bottom line of IE9 browser (is it called a 'status bar'?) clearly shows:

'javascript:my_function(<actual value>)' Is there any way to prevent it from showing function name and parameter value? I tried onmouseover="window.status='';"but it does not work

View 3 Replies View Related

Application Express :: Hide Column In Interactive Report In 3.2?

Feb 15, 2013

In Apex version 4.2 in interactive reports, you can stop users from hiding columns by unchecking a check box under column definition.Is there a way to stop users from hiding a specific column in version 3.2.

View 1 Replies View Related

Application Express :: Last Image Of Popup List Of Value Does Not Hide

Dec 27, 2012

i am using Apex 3.2,

i am display popup list of value item with out refresh when i select some value from Radio button. But Pop up item lable and element is Hide but in last image of popup list of value does not Hide .

How can i hide this image of popup list of values

i am using
<script>
function Show_On_Radio_Value_2(pThis, pThat, pValue, pLabel){
   var rv = html_RadioValue(pThis);
   var elm = document.getElementById(pThat);

[Code]...

View 0 Replies View Related

Application Express :: Hide / Show Column In Download To CSV?

Nov 27, 2012

I have an IR where I have to show a column in report, but hide it while downloading to CSV.

I get this by having a condition on this column - NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF')  I also have a column where I have to hide it in the report, but show it while downloading to CSV.

I am able to hide it, but this column doesn't show up while downloading.I am using this condition on this column NVL(:REQUEST,'EMPTY') IN('CSV','XLS','PDF','XML','RTF') APEX - 4.0.2

View 1 Replies View Related

Forms :: Hide A Single Row Field Of Multi Record Item?

Nov 3, 2010

Consider below is a multi record block rows, i want to hide "23". Is it possible using Set_Item_Instance_Property or any other built-in is there in oracle forms to hide a single row field in a multi record block.

11 12 13
21 22 23
31 32 33
. . .

View 3 Replies View Related

Reports & Discoverer :: How To Hide Username And Password In Web Show Document

Jul 1, 2013

I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.

View 6 Replies View Related

Forms :: Fields Disappear / Hide After Pressing Execute Query?

Feb 15, 2010

Something strange happens when i give execute query in a form (Oracle Forms 10g.). On executing query, one field disappeared but when i clicked on the location of the field it appeared again. I am not sure if this has something to do with visual attributes/display properties. This is happening only after migration to 10g.

View 7 Replies View Related

Forms :: How To Hide / Suppress User Defined Alert Messages

Dec 19, 2011

Is it possible to hide/suppress an user defined alert message in Oracle Forms application?

View 1 Replies View Related

Reports & Discoverer :: Hide One Frame And Display Other Depending On Parameter Value

Aug 22, 2010

I want to hide one frame and display the other depending on the parameter value . How could i make that ?

View 1 Replies View Related

Application Express :: Possible To Detect Status Of Hide / Show Region

Nov 11, 2012

Is it possible to detect the status of Hide / Show Region.

I have three hide/show regions RX,RY,RZ. When an event EX happens, then region RX should expand and the rest of the region should collapse. When an event EY happens, then region RY should expand and the rest of the region should collapse.
........
...
We can use this JS on DA to change the status of a region:

$("RX.uRegionControl").click();
$("RY.uRegionControl").click();

.....But, first we need to detect the status to know where to apply that DA. ? I am working on apex 4.2. theme 25.

View 2 Replies View Related

Application Express :: Dynamically Hide Show Page Items

Dec 14, 2012

Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.

In my page (form) I have 5 fileds iitems.

- Customer No
- Edit
- First Name
- Last Name
- Address

I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.

So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes

But it not working for me? Where am I go wrong?

View 2 Replies View Related

Application Express :: Hide And Show Region In A Page With Some Validations

Aug 4, 2012

I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.

View 2 Replies View Related







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