PL/SQL :: Static Table Creation In Oracle - Difference Between Static And Dynamic Table
Dec 11, 2012Static Tables Creation In oracle & Diff Between Static table ,Dynamic table
View 2 Replies
ADVERTISEMENT
SQL & PL/SQL :: Static Variable In Oracle
May 10, 2011Can we declare static variable in Oracle 9i.
View 2 Replies View RelatedForms :: How To Use Static IP Address In Oracle 10g
Jun 4, 2011how to use static ip address in oracle 10g.
View 5 Replies View RelatedNetworking And Gateways :: Oracle Database Not Connect From Outside LAN Via Static IP
Nov 17, 2011I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,
ie.select * from v$shared_server,
the output of this query is attached with this post.
Networking And Gateways :: Oracle Forms 6i Call Form Via Static IP?
Sep 6, 2011I had a query related to call_form function in forms 6i.How can I call a particular form via static ip(outside LAN),but the actual forms are stored in a server called "MAIN_SERVER" which resides in internal LAN domain.That is I have stored location of all my forms path(fmx)in my database table called "FORMS_LOCATION" in the MAIN_SERVER system under the directory "FORMS".From here only users can call all the forms by call_form function.To understand see the example below,
In the table FORMS_LOCATION,there is a column call "forms_path" which holds the value like,
//MAIN_SERVER/FORMS/EMPLOYEE.FMX;
(server_name,foldername,form_name)
In application the call_form just uses the column "forms_path" to call the form.like CALL_FORM("forms_path",no_hide) this statement will call the form from the main_server.
Here 1.MAIN_SERVER is the name of the server system where forms fmx is actually stored under the folder name "FORMS".When the users access the particular form the call_form function call the form from the MAIN_SERVER.Now there are no problem inside the LAN.Incase if I access the database and call the form outside LAN via internet through STATIC IP what happened was database was connected but call_form function failed and not calling the form because which does not know the MAIN_SERVER/FORMS/ path.
Because my user want to access the form outside lan via internet,so I tried replacing the above statement like //192.54.67.98/FORMS/EMPLOYEE.FMX' with static ip in the prefix instead of local server called MAIN_SERVER.But its not working again.How can I do this?.
SQL & PL/SQL :: Dynamic Table Creation Using Timestamps?
Nov 28, 2010I have a requirement to create the table monthly.The tablename will be the o/p of the following select query.
select 'TBR_AND_SECURITY_DEPOSIT'||TO_CHAR(sysdate, 'Monyy') from dual
I am trying to create the table for creating the backup of the existing table TBR_AND_SECURITY_DEPOSIT.
create table (select 'TBR_AND_SECURITY_DEPOSIT'||TO_CHAR(sysdate, 'Monyy') from dual) select * from TBR_AND_SECURITY_DEPOSIT
but it is throwing error as invalid table name.
Dynamic Pivot Table (Partition) Creation
Oct 31, 2010I have 2 tables , which can be mapped with a common column and the second table's rest of the columns should become like columns(like pivot) and in the second table itself 1 more column called value , this sum of the value becomes a value to the pivot column value. For this I am using CASE structure and I am writing the individual case for each column , but I am sure after some extent case don't work at all and I would like to do it dynamically( when ever the new entry will come into the source table , my proc has to pick automatically the new value and put the new value as part of pivot structure) , so pls share your inputs and if possible provide some sample code.
View 3 Replies View RelatedForms :: How To Connect Database With Static IP
Jun 4, 2011i got static ip from witribe a broadband company in pakistan i am trying to connect database from client side computer who connect with internet when i ping my server it reply with good speed but when i try to connect database the message appear (Unable to connect Destination) but it works very well with Local Area Network computers. More how can we change port 1521 in client sides
View 6 Replies View RelatedServices Not Registered With Static Listener?
Jun 11, 2013what configurations I do the static listener shows no services.Here is my listener.ora
:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=ELLISON9) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=ELLISON9) ) ) LISTENER11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1522)) )ADR_BASE_LISTENER = /u01/app/oracle My tnsnames.ora:ELLISON9 =
[code]...
How To Show Image On Report But Not Static Filename
Oct 22, 2004I am using Reports6i. I want to know how to show the image on the report but the image is not in static filename.
I used "Link File", but the "Source Filename" Boilerplate can only allow me hardcode the file path and file name.
Remark: The image is not stored in the database.
Forms :: Access File From Server Via Static IP At Outside LAN
Jul 4, 2011I am using oracle 9i release 2 and forms 6i.I have a question,I have stored all the fmx files under one folder in a single server called "MAINSERVER".From here only client system calls the forms.In am calling forms in call_form function like
call_form('\MAINSERVERFORMSemployee.fmx',no_hide);
here mainserver is the server name, forms is the folder name and employee is the form name in fmx format.My question is when i call form from server with in a network no problem but When i call form from outside lan that through internet via static ip forms are not called.I tried like this way call_form('\198.52.67.66FORMSemployee.fmx',no_hide).Here i have specified static ip and forms folder but is not working.
PL/SQL :: Only Display A Column Value One Time For A Record / Not A Static Value
Jan 7, 2013I am trying to only display a column value one time for a record, not a static value. The value changes and there can be many values. I do not think grouping will work since the Date value is dynamic. I am using Oracle for Toad 10.5. There are 4 records with this test data.
select Date, Person, Language, Country
from TableATableA
Date Person Language Country
01/25/2013 James English
12/20/2012 James English
US
[code]....
Application Express :: Possible Bug In Export Of Static Files In V4.1.1.00.23
Jun 8, 2012We recently updated to version 4.1.1.00.23, and need to do an export of our static files to migrate from our development to test (ApEx run-time) platform. When our DBA attempted to run the export script (we had renamed it from static_file.sql to browser_detect.sql), he received this error:
SQL> @browser_detect.sql
Set Credentials...
Check Compatibility...
Set Application ID...
...static file repository
p_notes=> '');
*
ERROR at line 14:
ORA-06550: line 14, column 5:
PLS-00103: Encountered the symbol "P_NOTES"
when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "(" was substituted for "P_NOTES" to continue.
ORA-06550: line 14, column 18:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset
We took a look at static_file.sql, and noticed this:
declare
l_name varchar2(255);
l_html_id number := null;
begin
l_name := 'browser_detect.js';
wwv_flow_html_api.remove_html(
[code].......
The comma is missing after the p_flow_id parameter. This appears to be a bug in the export. It appears to be happening pretty consistently (other static files for this application, other static files for other existing applications).
I did a search of the forum to see if this issue reported this and checked listing on OTN and I don't see any reference to this particular issue. We're hesitant to just add the comma right now since we don't know whether there may be any other issues in the file it's generating.
Security :: Where To Store Static SQL (Application Or Database) And Why
Feb 6, 2013 understanding where to store the static SQL code (Database or Application).Consider a scenario, that I am executing a simple SQL from Java which is returning some value, and it will not be changed in future.
should I store this sql in java application code or in database in form of procedure/function and returning the result to Java. Is there any security/performance impact?
PL/SQL :: How To Display Pseudo Static Index Using Select Statement
Jul 20, 2012I have to display a 24 hours time as an index. (00:00 - 23:00) That is easy, if the data exists.
But, if the data is not regularly exists on specific hour (the time/hours is not regular, i.e: 00:00, 01:00, 05:00, 08:00, 10:00, 11:00, 23:00), then it is OK for a TABLE, but not for a CHART.
Here is the story:
I wrote an SQL statement that can "choose" what to display respectively to the the available time. The result will be displayed on the chart: Days or Time is used for X-Axis, and the respective Value on the Y-Axis.
Example:
+ if the data consists of "days" (i.e: the last 5 days from now, 16/07/2012, 17/07/2012, 18/07/2012, 19/07/2012, 20/07/2012), then the chart will show those dates on the X-Axis.
+ if the data consists of "hours" (i.e: 1 single day, from 00:00 hour - 23:00), then the chart shows hours on the X-Axis.
If the 'hours' are not regular, means: there is no data on specific hours, the query result is also not regular, means: the X-Axis-value 'jumps' irregularly.
Question:
Is it possible to query our own static value?
for example:
select 'hello' from dual --> result: "hello", 1 column, 1 row
But how to display this in multiple rows, i.e.:
Time
*****
0
1
2
3
4
5
...
...
23
Note: the X-Axis on the chart template can be only customized for 1 single mode, example: "Days", but of course it is not going to show up properly if the query result are in "Hours". It means: I have to find the workaround on the SQL Query.
DB: ORA 11
Virtual Host Name Must Be Static And Resolvable Consistently On Network
Apr 2, 201310g
SLES 11
Oracle® Enterprise Manager Grid Control Installation and Configuration Guide
10g Release 5 (10.2.0.5.0)
Part Number E10953-1518 Configuring Enterprise Manager for Active and Passive Environments18.1 Using Virtual Host Names for Active and Passive High Availability Environments in Enterprise Manager Database ControlSet Up the Alias for the Virtual Host Name and Virtual IP Address
You can set up the alias for the virtual host name and virtual IP address by either allowing the clusterware to set it up automatically or by setting it up manually before installation and startup of Oracle services. The virtual host name must be static and resolvable consistently on the network. All nodes participating in the setup must resolve the virtual IP address to the same host name. Standard TCP tools similar to nslookup and traceroute commands can be used to verify the set up.
Application Express :: Can Use Static List With Skillbuilders SuperLOV V2.0 Plugin
Oct 1, 2012I would like to convert some existing application popup LOV items that currently use a static list for the LOV values.I have not been able to find instructions on how to use the existing popup static list (or create a new static list) with the new SuperLOV plug-in. Is this possible to do?
If an example or instructions are available, a link to these.
Real Application Clusters :: Add Static Entry For Scan Listener
Sep 3, 2012I am running a two node rac on grid 11.2 and db 11.2.0.3. My application does not like the scan listener, therefore I have to configure the remote listener parameter to the vips of the two hosts, which is working fine.
But it comes out the the system needs the service registered with the scan listener. So. How can I add a static service entry for my scan listener ?
PL/SQL :: Avoid Multiple UNION Statements And Get Static Values In Single SQL?
Dec 31, 2012Version oracle 11g
Is there a way to avoid multiple UNION statements and get statitc values in single SQL?
select 'Week1' as term from dual
UNION
select 'Week2' as term from dual
UNION
....
....Some functionality like selecting from dynamic table column-rows.... like .. "select term from table(term(rowvalues('Week1', 'Week2'...'Week5')) from dual" or something like that
Application Express :: 4.2 Upgrade - Static File Upload Mim - Type Error?
Apr 17, 2013After Upgrading to Apex 4.2
When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.
Listener Port Conversion To Static Port
Mar 2, 2012For every connection, oracle listener creates a unique dynamic port. Is this can be made static port for all connection? This a query raised in our penetration testing.
Listener log Sample :
02-MAR-2012 17:40:28 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.3.12)(PORT=3773))
02-MAR-2012 17:39:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.84)(PORT=38192))
SQL & PL/SQL :: Difference Between File Catproc That Run After Creation Of Database In Oracle 9i /10g / 11g R2
Aug 18, 2010I want to know what is the difference between the file catproc that we run after creation of the database in the Oracle 9i,10g and 11g r2. I have run that file in 11g R2 but it is taking more time and more over there are many new things that i saw in 11g R2 than what were there in 9i and 10g.
View 11 Replies View RelatedSQL & PL/SQL :: Table Creation - Import Data In Oracle?
Sep 20, 2012i have 1 xcel sheet in formatted data i want to import data in oracle table .. how do i do dat??
View 5 Replies View RelatedSQL & PL/SQL :: Dynamic Function - Create Physical Table And Return Table Name In Out Variable
Aug 30, 2011I am trying to execute dynamic SQL in Stored Function and I don't know how to do this.
Explanation:
In the function I am calling pr_createtab is procedure which will create a physical table and return the table name in the out variable v_tbl_nm.
I need to query on this dynamic table and return the result as return result. But i am not able to do it.
Here T_web_loylty_report_table is a type.
CREATE OR REPLACE function CDW_DSS.f_ReturnTable(i_mrkt_id in number, i_cmpgn_year in number)
return T_web_loylty_report_table is
v_tbl_nm varchar2(50);
i_cntry_cd varchar2(20);
v_sql_str varchar2(32567);
[code]......
SQL & PL/SQL :: New Table Creation From Different Databases?
Apr 9, 2013I have two tables having same name in two different databases.i have to create a new table with these two tables in a new database.
But if one table have 2 columns and another table having three columns I have to create a new table with three columns..
SQL & PL/SQL :: External Table Creation
May 23, 2011i had small query on external tables. i had (.csv) file outside the database. In this file, one column will be added monthly. i need to create the external table dynamically by adding the column for every month.
How the procedure can be created for this requirement.
Adding Check After Table Creation
May 23, 2009I created a table but I want to add the Unique check to it as I forgot to apply it to the table when I created it.Is it possible to make the field Unique after having created the table or do I have to drop the table and re-create it?
View 3 Replies View RelatedTable Creation Inside Function
Feb 25, 2012i am trying to create table inside function where in after creating table when am trying to access the table with select statement oracle is throwing error 'Table/view doesnot exist -00942', below is the code snippet
create or replace function example (mkey in varchar2) return varchar2
is
g_key varchar2(100);
l_tbl_ntext exception;
pragma exception_init(l_tbl_ntext , -942);
begin
begin
execute immediate 'select * from example1';
exception
when l_tbl_ntext then
null;
end;
execute immediate 'create table example1(skey varchar2, g_key varchar2) storage(buffer_pool, keep)';
end example;
/
select * from example;
Relationship - Table Creation With Keys Looks?
Feb 24, 2007the relationship on my script.What I want to do is make it possible to assign many courses to a student.But I have read a few books on foreign keys and primary keys, and I still dont get how to go on doing this....
This is how the table creation with the keys looks right now...
CREATE TABLE CAMPUS (
CAMPUSID NUMBER(4) NOT NULL,
NAME VARCHAR2(80) NOT NULL,
CONSTRAINT CAMPUS_PK PRIMARY KEY (CAMPUSID));
[code]...
SQL & PL/SQL :: Creation Of Temp Table Within Procedure
Aug 17, 2010I need to create a temp table within a stored procedure. I want to apply some logic on the table, and then delete it when it is completed in runtime -- all inside the stored procedure.
View 13 Replies View Related