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?
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;
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.
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
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.
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 RelatedI 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 RelatedI 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,
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*".
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]....
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.
Is there a way to find when was a database role created and who has created?
View 5 Replies View Relatedtell me if a REFRESH GROUP is automatically created when a materialized view is created?
View 3 Replies View RelatedIt 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
Explain me steps to do vertical partitioning in oracle .
View 3 Replies View RelatedWhere are the server side procedures are stored? Where are the server side procedures are visible??
View 5 Replies View Relatedhow can i set the alignment of the text field in report 6i.
View 10 Replies View RelatedI 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 RelatedI 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
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
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
how to upgrade Oracle SERVER jvm version
View 2 Replies View RelatedI 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?
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 RelatedWhen 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".
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.
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?
How i can run adobe acrobat in the client side and maximize it ?
Note: i am using oracle 10g.
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?
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();