Application Express :: How Vertical Left Side Menus Created

Jun 11, 2012

I was keen on creating left side vertical menus instead of using a tab for every page to organize my application better. An example is

[URL].......

I tried creating a list and attaching it to a page. Did not work. Still investigating this. Specifically, what list option that person is using. Not sure, if its really a list or maybe the vertical navigation bar?

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: TRIM Function - Remove Symbol Only From LEFT Or RIGHT Side

Feb 22, 2011

Is there any possibilites to remove the symbol '*' only from LEFT or RIGHT side, instead BOTH the side.

select '>' || trim (both '*' from '***removing stars at both sides***') || '<' "Stars removed" from dual;

View 4 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

Application Express :: Shuttle / How To Reference Selected Items On The Right Side

Sep 13, 2012

I have a simple shuttle:

1 Adam
2 Baker
3 Charlie
4 Delta
5 Echo
6 Foxtrot

Select Name D, UserID R from UserTable

The values are stored in a VARCHAR2 field MULTI_USER (for example 1:2:4:6) When I want to get the names back from the selected item, how do I reference the colon-separated items?

For example:

Select Name from UserTable
where UserID in (select MULTI_USER from MULTI_USER where MULTI_USER_ID = 1)

should return:

Adam
Baker
Delta
Foxtrot

View 2 Replies View Related

Application Express :: Chart With Vertical Y-axis Title Having Horizontal Letters?

Oct 24, 2012

I've edited the XML on the Chart Attributes page but I don't find atrtributes to rotate the y-axis title (<text>TITLE</text>) nor the letters themselves in the title. What I'd like is something very close to

T
I
T
L
E

But what I get is a horizontal title rotated -90 degrees. I've looked at lots of Anychart documentation but don't find anything that seems to fit with the XML already given on the Chart Attributes page. I've seen the "rotate" attribute but I don't know where it would go and even then, I'm sure it only rotates the title as a unit and not the individual letters.

View 0 Replies View Related

Application Express :: Enkitec Navbar Vertical List Appears Momentarily?

Jul 24, 2013

Apex 4.2.0.00.27Firefox 22.0, IE 8 Just started using the Enkitec Navbar, and we have noticed that when a page is rendered a vertical list always appears momentarily before being replaced with the Navbar list. It happens on all applications we have installed it on, and every time a page is refreshed. 

View 13 Replies View Related

Application Express :: How To Automatically Send Report After It Is Created

Sep 16, 2013

I am beginner . I found this tutorial how to save and access report.Storing and Accessing Reports in the Database In that tutorial report is saved onclick.Is there a way to automatically email report everytime report is generate or I should first save it (PDF, CSV,..) with SQL script and then email it? I also found that in Interactive report there is page process that can send e-mails. Is it possible that page process send e-mail with report or report should be also saved before sending? The reason for this is that we want to have a history of created reports.

View 6 Replies View Related

Application Express :: How To Add Delete Function To A Form With Report That Is Already Created

Apr 11, 2013

I am not familiar with form with report in APEX. I have a lot of forms with reports that was created before, but they have only create buttons. Now I need to add edit and delete buttons. I wish I do not have to recreate forms with reports. But when I tried to add delete function by comparing a form with delete button created by APEX, but it does not work. the delete button does not react at all.

setting is as follows:

button style: template based button
button template: Button
button type: normal
action: redirect to URL
execute validation: NO
URL target: javascript:apex.confirm(htmldb_delete_message,'DELETE');
database action: SQL delete action
condition type: value of item / column in expression1 is not null
expression1: P2172_ALIAS_ID

I also enable the delete in the process of :"Process Row of SOR_ALIAS"

If I set action of delete button as submit page, I can delete the row, but no standard popup warning,

View 2 Replies View Related

Application Express :: How To Create Validation Only For Created Rows In Tabular Form

Sep 19, 2012

Is it possible to create a validation for tabular form which will be fired only for created?

There is a possibility in APEX 4.1 to choose two types of "*Execution scope*" first is "*For created and Modified Rows*" and second is "*All Submitted Rows*".

View 3 Replies View Related

SQL & PL/SQL :: Printing Tables Side By Side

Mar 8, 2012

Here i am displaying the multiplication tables by given number...the problem is the tables are displaying one after another...i need to print it by side by side like..

1*1=1 2*1=2 3*1=3
` ` `
` ` `
` ` `
1*10=10 2*10=20 3*10=30
....

the written code is

declare
a number:=1;

[Code]....

View 9 Replies View Related

PL/SQL :: Updating 2 Tables Side By Side

Apr 4, 2013

sqlplus experts,

How do I update Table2(idno) with values of Table1(idno)? By the way there are other columns which i do not want to be touched. This is just to create a match parent-child table test data.

Example:

Table1

idno
===
100
101
102
103

Table2

idno
===
any no
any no
any no
any no

I want all idno values in Table2 to be identical with Table1. It can be any order as long as the value is 1 to 1. I just want it populated for test data purposes.

View 28 Replies View Related

Server Administration :: Find When Database Role Created And Who Has Created?

Feb 14, 2013

Is there a way to find when was a database role created and who has created?

View 5 Replies View Related

REFRESH GROUP Is Automatically Created When A Materialized View Is Created?

Aug 17, 2012

tell me if a REFRESH GROUP is automatically created when a materialized view is created?

View 3 Replies View Related

Real Application Clusters :: Why Archived Log Of Instance1 Got Created In Instance2

Jan 17, 2013

It is a 2 nodes RAC. I found that there are archived log of instance#1 created in instance#2. It is strange.

instance#1
[oracle@server1 dbs]$ ls -l /appl/erp/arch/orcl/
total 1501340
-rw-r-----  1 oracle erpdba 49469952 Jan 17 09:33 1_781_715695404.arc
-rw-r-----  1 oracle erpdba 50551808 Jan 17 09:34 1_782_715695404.arc
-rw-r-----  1 oracle erpdba     1024 Jan 17 09:39 1_785_715695404.arc
-rw-r-----  1 oracle erpdba 49051648 Jan 17 10:00 1_786_715695404.arc
-rw-r-----  1 oracle erpdba 83065344 Jan 17 10:00 2_615_715695404.arc
-rw-r-----  1 oracle erpdba 51148800 Jan 17 10:01 1_787_715695404.arc
-rw-r-----  1 oracle erpdba     1024 Jan 17 10:01 2_616_715695404.arc
-rw-r-----  1 oracle erpdba 48924672 Jan 17 10:01 1_788_715695404.arc
-rw-r-----  1 oracle erpdba 48935424 Jan 17 10:01 1_789_715695404.arc
-rw-r-----  1 oracle erpdba 23964160 Jan 17 10:06 1_790_715695404.arc
-rw-r-----  1 oracle erpdba 51796480 Jan 17 10:07 1_791_715695404.arc
-rw-r-----  1 oracle erpdba 52080640 Jan 17 10:08 1_792_715695404.arc
-rw-r-----  1 oracle erpdba 51973120 Jan 17 10:09 1_793_715695404.arc

instance#2
[oracle@server2 dbs]$ ls -l /appl/erp/arch/orcl/
total 1501340
-rw-rw----  1 oracle erpdba 101348352 Jan 16 15:46 2_605_715695404.arc
-rw-rw----  1 oracle erpdba 101351424 Jan 16 16:05 2_606_715695404.arc
-rw-rw----  1 oracle erpdba 101347840 Jan 16 16:06 2_607_715695404.arc
-rw-r-----  1 oracle erpdba 101350400 Jan 16 16:55 2_596_715695404.arc
-rw-rw----  1 oracle erpdba   3522560 Jan 16 18:13 2_609_715695404.arc
-rw-rw----  1 oracle erpdba  47719424 Jan 17 09:33 2_610_715695404.arc
-rw-rw----  1 oracle erpdba      7168 Jan 17 09:33 2_611_715695404.arc
-rw-rw----  1 oracle erpdba   5175296 Jan 17 09:34 1_783_715695404.arc
-rw-rw----  1 oracle erpdba   6170112 Jan 17 09:34 2_612_715695404.arc
-rw-rw----  1 oracle erpdba  50551808 Jan 17 09:34 1_782_715695404.arc
-rw-rw----  1 oracle erpdba      1024 Jan 17 09:34 1_784_715695404.arc
-rw-rw----  1 oracle erpdba 102879232 Jan 17 09:36 2_613_715695404.arc
-rw-rw----  1 oracle erpdba 103360512 Jan 17 09:38 2_614_715695404.arc

View 8 Replies View Related

SQL & PL/SQL :: Vertical Partitioning In Oracle

Mar 19, 2013

Explain me steps to do vertical partitioning in oracle .

View 3 Replies View Related

Where Server Side Procedures Are Stored

Jun 2, 2009

Where are the server side procedures are stored? Where are the server side procedures are visible??

View 5 Replies View Related

Reports & Discoverer :: How To Set Vertical Alignment In 6i

Nov 5, 2010

how can i set the alignment of the text field in report 6i.

View 10 Replies View Related

SQL & PL/SQL :: Making Vertical Records To Horizontal

Aug 18, 2010

I need to build a query on making a vertical records to horizontal records. I did read somewhere saying that we can use decode function. But im still trying to understand how decode function can make a vertical records to horizontal records.

View 4 Replies View Related

SQL & PL/SQL :: Convert The Table From Vertical To Horizontal

Apr 21, 2010

I have a table like the

WEEK STORE SALES
1 A 12
2 A 18
3 A 20
4 A 25

I need a query to build out put like

store week1 week2 week3 week4
A 12 18 20 25

View 4 Replies View Related

Forms :: Vertical Text On Buttons

Jan 5, 2011

Refresh my memory if there's a way to display vertical text on buttons in forms?

e.g. v
e
r
t
i
c
a
l

View 3 Replies View Related

Forms :: To Output Query In Vertical Way

Dec 27, 2011

i have output query in 1 row, for example

Id Name Salary
100 John 2000

i need to output the same query in vertical way like:

100
John
2000

View 3 Replies View Related

Upgrade Server-Side - Oracle DB JVM?

Sep 28, 2012

how to upgrade Oracle SERVER jvm version

View 2 Replies View Related

PL/SQL :: Client Server Application That Created Using MS-SQL Server Database

Apr 2, 2013

I have a Client Server application that I created using an MS-SQL Server Database (MS-SQL Server 2008 R2 Express).Since MS-SQL Server has wide range (and number) of DATA_TYPEs, I elected to dedicate a few of those DATA_TYPEs to application-specific processing (mainly the MONEY and BOOLEAN DATA_TYPES).

I further decided that within the Client Application that the general processing of a particular field would be determined by the corresponding DATA_TYPE stored in the database.

The DATA_TYPE of a particular field within the SQL Server database and may be determined by querying:

"select DATA_TYPE from INFORMATION_SCHEMA.Columns where ( ( Column_name = 'my_Field' ) and ( Table_Name = 'myTable' ) )"

I also extract/use other DATA_TYPE information as needed/appropriate.

With this information the Client Application can consistently process a MONEY (a DATA_TYPE in MS-SQL Server) differently than perhaps either a DECIMAL or a BIGINT (two other DATA_TYPEs in MS-SQL Server). I have to create the field with the correct DATA_TYPE in the database, but after that I don't have to worry about it.

I am now moving over to an Oracle Database (Oracle Database Express Edition 11g Release 2). And I would like to have the same (or similar) functionality as described above.

Oracle has fewer DATA_TYPES so it is more difficult to tie an application-specific-datatype to an Oracle-database-specific-DATA_TYPE. There simply aren't as many to "sacrifice" to my application-specific-processing. I don't want to treat every NUMERIC field as "the-apps-money-type."

With Oracle I can associate "the-apps-money-type" with, let's say, a NUMERIC(9,2) and then the Client Application will treat all NUMERIC(9,2) as "the-apps-money-type."The Client Application queries the Oracle database for DATA_TYPE, DATA_PRECISION, and DATA_SCALE to make this determination.

But this approach does not appeal to me, suppose that I have other NUMERIC(9,2) fields that are not of "the-apps-money-type." How can I set and then later determine, from the Oracle backend, if the NUMERIC(9,2) field is meant to be used as "the-apps-money-type" or just a regular number?

Is there some way I may create some sort of "sub DATA_TYPE" in Oracle?I considered indicating this in the COMMENTS field that is associated with particular field. Then query for that comment when I process NUMERIC DATA_TYPEs. But the COMMENTS field does not seem to make it into user_tab_columns or all_tab_columns.

(With Oracle SQL Developer one can create/modify/delete the user created tables/fields. COMMENTS may be added to particular fields within a table--these are the COMMENTS that I am referring to above).What I would like to do, and most direct approach to me, would be to somehow create a user defined DATA_TYPE that is simply:

1) a user defined DATA_TYPE name (like, MY_MONEY_TYPE),
2) associated with an Oracle Built-in datatype (like NUMERIC(9,2).

Then when the client application queries user_tab_columns the field may be processed appropriately. If I cannot do that, perhaps there is somewhere else that I may set and subsequently query for this sort of information. What is(are) the most direct way(s) to implement the functionality described above?

View 4 Replies View Related

Forms :: Horizontal And Vertical Scroll Bar For Tabular

Aug 20, 2011

i need to create a form with 15 col and 10 records in tabular format to display records from the table....i done it with vertical scroll bar ..bt.i need both horizontal and vertical scroll bar for that tabular.

View 2 Replies View Related

Forms :: Vertical Scroll Bar Is Not Showing Properly?

Mar 1, 2010

When I first access the form and query for records, it works as per the expectation and with scroll bar to scroll up and down. But when I do "View>Record>Last", it reaches to last record, but not able to use the scroll bar to scroll the records up(I am on last record, so can't do downward scrolling).

The scroll bar is displaying in Full, no room to scroll up down.It happens only when I do "View>Record>Last".

View 2 Replies View Related

Client Tools :: Vertical Display Of Table

Jun 29, 2010

I would like to format my output for the select query.

Example:

SQL>select empno, ename from emp;

empnoename
1987766Jack Blake
187765Greg Ni

But I would like to get the output in the below format

EMPNO:.................1987766
ENAME:.................Jack Blake

EMPNO:.................187765
ENAME:.................Greg Ni

I will need printing the column name. I would like to know how do we address the column name to print.

View 24 Replies View Related

RAC & Failsafe :: Load Balancing At Server Side

Oct 28, 2010

I've configure TAF and Load Banalcing, both of server side some days ago. And now, I find Node 2 is accessed more than node 1. I upload some images here, anything you need to clarify information more, I can give.

Node 2 is often at 40%-55%, some time to 77%.

Node 1 is often 5-12%

Service TAF was configured

Show TAF service by crs

The remote listener

Were I wrong?

View 10 Replies View Related

Forms :: Run Adobe Acrobat In Client Side Using 10g

May 10, 2010

How i can run adobe acrobat in the client side and maximize it ?

Note: i am using oracle 10g.

View 8 Replies View Related

Security :: Query Regarding Client Side Wallet

Jul 11, 2012

I need few clarifications regarding oracle wallet.

db version: 11.2.0.3.2 (Enterprise Edition)

We have a requirement to run shell scripts calling stored procedures for specific activities, which are run on database server. We do not want to store passwords in shell scripts and decided to use Secure External Password Store for hiding passwords instead of os authentication method. need few clarifications on the below.

1) Currently, we are creating oracle wallet entry on db server and making modifications in sqlnet.ora file accordingly. Is it good to use like this or we should do this only on a client machine?
2) Do we need any licensing to use this option?
3) Any knows issues with using oracle wallet?
4) Can we use orapki for creating oracle wallet instead of mkstore?
5) Any knows issues we face during startup and shutdown of db activities?

View 1 Replies View Related

Forms :: Pie Chart And Vertical Bar Graph In Oracle 10g

Oct 8, 2013

I have two graph pj item in oracle block one is pie chart and other is vertical bar graph... there is color display in bottom of pie graph which is red=50,yellow-30 and orange=20 ..and in vertical bar red=50,but orange=30 and yellow is 20 ..means orange and yellow is interchange in bar graph..how i can same the both graph value..

the graph is populate through cursor and graph properties is setting through set_custom_propert();

View 1 Replies View Related







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