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..
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.
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.
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?
We are on oracle 11.2.0.2 on Solaris 10. I dont have acces to the db server but connect to the db from the client side using sqlplus. though I have dba privilege (at oracle level) but no access to db server at os level. I also dont have access to enterprise manager console where such information is available.
I want to set up monitoring so that I can get a mail when the space falls below some threshold like say tablespace is 90% full. Is it possible to get mail from pl/sql script for example?
I'm using Oracle8i, with VB6 as front end When i try to connect Oracle using RDO in VB i get an error message from Oracle It is S1000:Oracle ODBC.ora Ora:1043 User Side Memory Corruption.
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?
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)
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 inherited a query that union alls 2 select statements, I added a further field to one of the select statements ( a date field). However I need to add another dummy field to the 2nd select statement so the union query marries up I have tried to do this by simply adding a
select 'date_on' to add a field called date on populated by 'date_on' (the name of the column in the first query)
however when I run the union query i get the error Ora-01790 expression must have same datatype as corresponding expression.
Oracle developer suite 10g i am installing 10 developer in server can you explain me how to run client side forms and report web-throw witch address i tel him to client.
I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.
I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.
I am currently printing from a DOS window to a Zebra printer as follows:
-Start, Run -ftp to the print server -enter userid and password -type in put <filename>.zpl
However, at the supplier site, I am being asked for a simple print command that would send the .zpl file to th printer that would print the label (Open a file, click on print).
Here are the printer details that I am using:
Model: Zebra170XiII Host: sfezebra Version: V18.7.1 Serial Number: 716314
I have table data in which we are entering Visitor's information.We need a monthly report with the count .There are some months which dont have data .So Names of month are not coming .Can i Print Month Name with 0 visitor.
Sample Data
Quote:ID Name Visit_date 1 ABC 01/02/2011 2 DEF 03/04/2011
im using query
Quote:SELECT count(ID) Nos ,TO_CHAR(visit_date,'MONTH') Month FROM DELEGATE_DETAILS WHERE visit_date BETWEEN '01/02/2011' AND '01/04/2011' GROUP BY TO_CHAR(ARR_DATE,'MONTH') ORDER BY TO_CHAR(ARR_DATE,'MONTH'); Output Quote:Nos Month 1 February 1 April
Desired Output:- Quote:Nos Month 1 February 0 March 1 April
I have problem writing condition to exit the for loop..How can I exit after finish printing
PROCEDURE find_stu_age_given_id(s_sid number) is cursor c1 is select * from student where sid=s_sid; age number; begin For i in c1 LOOP age :=to_char(SYSDATE -i.dob); dbms_output.put_line(i.sid ||' age is '|| age/365); END LOOP; end find_stu_age_given_id;
I have This Code working on the local form builder after starting the oc4j and run the form. but using OLE2.
but when using the Cleint_ole2 on the application to invoke an object on the client machine.
but nothing happend, while i have tested the webutil configaration and its working fine.
i use this code to print any word document without openning it. and here is the code in when_button_pressed
DECLARE application CLIENT_OLE2.OBJ_TYPE;-- Declare a object OLE args CLIENT_OLE2.LIST_TYPE; -- Declare List of Parameters to obj. OLE begin application := CLIENT_OLE2.CREATE_OBJ('WORD.Basic'); -- Start a process WordBasic args:= CLIENT_OLE2.CREATE_ARGLIST;-- Create a list of Parameters -- Add param. file_name with path(x. c: empmy.doc) :blk01 is my block
We need to generate barcode through oracle forms and print the barcode using Zebra Printer.
How to generate the barcode using oracle forms and which software we should use to generate the barcode as well as how can we print the barcode label with customize information on label with barcode.
I'm developing now in 11g and i have some reports that i want to send directly to the printer. I been having some troubles and as i searched the web, i saw that for 9i and 10g, this was not possible without using orarrp. But i can't find any info about this for 11g. Is this true that i can only let user print direct using this tool? Plus, is this tool available for linux x64? Can i add the printer to the server and would it work now?
We access the 10g forms and reports application through citrix and non citrix environments, when we are trying to print the screen from citrix environment the screens are getting shaded but if we print through non citrix environment screens are printing fine.
I am building an application to edit database data through interactive reports. I would like to add a button to open a pdf file of the report, where the user can save or print it. I tried going to Shared Components>Report Queries and then create. I went through the steps but when I get to the end where it says "Test Report" I get this error:
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified
What can i do to fix this, or is there an easier way to do this?
I am using APEX 4.0.2.00.09
This app will be distributed to other computers if that makes any difference.
I'm using APEX 4.0, and i don't have access to BI Publisher for printing.
That needs to print off customer address labels. I have a pl/sql query that gets the customer name and address and puts it into mailing address format. Ex. Mike Smith 555 Oracle Dr Los Angelas CA 40455
When i try to print from the browser, it prints really bad with the URL, page numbers etc.
These will actually print out on label paper, and they will be cut and used accordingly.
What i tried so far:
Manipulating the print CSS:
This worked slightly in Firefox, but doesn't work at all in Internet Explorer
Tried adding a third party friendly print button to the application. This doesn't work
I would even be ok for these to print to a PDF or RTF format to download then print off, but i don't have BI Publisher.