How can we set the profile option from a PL/SQL procedure?
- by P Sharma
How can we set the profile option from a PL/SQL procedure?
Search Results
Search found 244 results on 10 pages for 'oracle10g'.
Page 7/10 | < Previous Page | 3 4 5 6 7 8 9 10 | Next Page >
-
-
How does contains() in PL-SQL works?
- by Artic
Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something else. It is hardcoded and couldn't be changed.Read the article
-
MVC + Nhibernate + Oracle Schema Configuration
- by Orkun Balkanci
Our customer wants us to use a connectionstring with username = "external" and add schemaName "original" infront of our queries like: "select columnA from original.TableA" I dont want to change mapping files which are shared by other projects, tried adding default schema as: <property name="default_schema">original</property> But…Read the article
-
Oracle database link
- by Sunit
I'm currently using Windows Authentication with 2 Oracle servers - SP3DSMP1 & SP3DSMP4. I created a database link on SMP1 to connect to SMP4 as: SQL create public database link LINK_SMP4 2 connect to CURRENT_USER 3 using 'SP3DSMP4'; Database link created. However when I try to do a query, I get the error: ERROR at line 1: ORA-01017:…Read the article
-
How is my id being generated with JPA using Hibernate with the Oracle 10g dialect?
- by JavaRocky
I have some code: @Id @SequenceGenerator(name = "SOMETHING_SEQ") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SOMETHING_SEQ") @Column(name = "SOMETHING", nullable = false) private Long id; How is hibernate providing my id? I see in my database there a single sequence named 'hibernate_sequence' and no other hibernate …Read the article
-
Is there a way to parametrize ORACLE 10g SELECT-query with IN-clause
- by matti
I saw couple of SO questions (SO) concerning SQL-server. For SQL-server there was no decent solution. All were hacks/workarounds. What about Oracle? Is it same answer (Paremeterizing each value)? Any Oracle example without LINQ would be appreciated (I have .NET 2.0). Thanks & BR -MattiRead the article
-
MySQL developer here -- Nesting with select * finicky in Oracle 10g?
- by John Sullivan
I'm writing a simple diagnostic query then attempting to execute it in the Oracle 10g SQL Scratchpad. EDIT: It will not be used in code. I'm nesting a simple "Select *" and it's giving me errors. In the SQL Scratchpad for Oracle 10g Enterprise Manager Console, this statement runs fine. SELECT * FROM v$session sess, v$sql sql WHERE…Read the article
-
Export large amount of data from Oracle 10G to SQL Server 2005
- by uniball
Dear all, I need to export 100 million data rows (avg row length ~ 100 bytes) from Oracle 10G database table into SQL server (over WAN/VLAN with 6MBits/sec capacity) on a regular basis. So far, these are the options that I have tried and a quick summary. Has anyone tried this before? Are there other better options? Which option would be…Read the article
-
how to find top three highest salary in emp table in oracle(sql)
- by SunilRai86
how to find top three highest salary in emp table in oracle(sql)Read the article
-
How do you set the profile option from a PL/SQL procedure?
- by P Sharma
How do you set the profile option from a PL/SQL procedure?Read the article
-
How Internally BTree and Bitmap Index stored in oracle?
- by P Sharma
I want to know what value is stored against BTree Index and Bitmap Index in oracleRead the article
-
Invoking a function call in a string in an Oracle Procedure
- by DMS
Hello, I writing an application using Oracle 10g. I am currently facing this problem. I take in "filename" as parameter of type varchar2. A sample value that filename may contain is: 'TEST || to_char(sysdate, 'DDD')'. In the procedure, I want to get the value of this file name as in TEST147. When i write: select filename into…Read the article
-
NHibernate unable to create SessionFactory
- by Tyler
I'm having a bit of trouble setting up NHibernate, and I'm not too sure what the problem is exactly. I'm attempting to save a domain object to the database (Oracle 10g XE). However, I'm getting a TypeInitializationException while trying to create the ISessionFactory. Here is what my hibernate.cfg.xml looks like: <?xml…Read the article
-
Retrieve data in group based on the Value of other column
- by Seema
I have one table with the following Column. BoxNumber Status 580 4 581 4 582 4 583 4 584 2 585 2 586 4 587 4 588 4 589 4 590 2 591 …Read the article
-
Is there a way to give a subquery an alias in Oracle 10g SQL?
- by Matt Pascoe
Is there a way to give a subquery in Oracle 11g an alias like: select * from (select client_ref_id, request from some_table where message_type = 1) abc, (select client_ref_id, response from some_table where message_type = 2) defg where abc.client_ref_id = def.client_ref_id; Otherwise is there a way to…Read the article
-
Do I need to write a trigger for such a simple constraint?
- by Paul Hanbury
I really had a hard time knowing what words to put into the title of my question, as I am not especially sure if there is a database pattern related to my problem. I will try to simplify matters as much as possible to get directly to the heart of the issue. Suppose I have some tables. The first one is a list of…Read the article
-
how to get date from week and day of the week in oracle
- by Deven
i am having week number and day of that week then how can i get date example week number=20 and day of that 20th week is friday then ? what is date?Read the article
-
Oracle forms API - c-based compile error
- by ShoeLace
i am trying to compile a c-based forms api program on Linux x86_64 using command gcc -m32 -I"$ORACLE_HOME/forms/api" -L"$ORACLE_HOME/forms/lib" -L"$ORACLE_HOME/lib" -ld2f fapi.c it fails with a bunch of undefined references. $ORACLE_HOME/lib/libd2f.so: undefined reference to `sifom'…Read the article
-
PL-SQL - Two statements with begin and end, run fine seperately but not together?
- by Twiss
Hi all, Just wondering if anyone can help with this, I have two PLSQL statements for altering tables (adding extra fields) and they are as follows: -- Make GC_NAB field for Next Action By Dropdown begin if 'VARCHAR2' = 'NUMBER' and length('VARCHAR2')>0 and length('')>0 then execute…Read the article
-
Is oracle dropping database oracle XE ?
- by dr jerry
I'm trying to access the download for oracle XE on windows but it fails with 404 error. Is Oracle leveraging its possession of mysql or is it a temporarily error?Read the article
-
Can anybody tell me how to use TKPROF utility along with syntax and parameters
- by P Sharma
Can anybody tell me how to use TKPROF utility along with syntax and parametersRead the article
-
Muti-Schema Privileges for a Table Trigger in an Oracle Database
- by sisslack
I'm trying to write a table trigger which queries another table that is outside the schema where the trigger will reside. Is this possible? It seems like I have no problem querying tables in my schema but I get: Error: ORA-00942: table or view does not exist when trying trying to query…Read the article
-
How to map oracle timestamp to appropriate java type in hibernate?
- by jschoen
I am new to hibernate and I am stumped. In my database I have tables that have a columns of TIMESTAMP(6). I am using Netbeans 6.5.1 and when I generate the hibernate.reveng.xml, hbm.xml files, and pojo files it sets the columns to be of type Serializable. This is not what I expected, nor…Read the article
-
ORACLE: Parameter reference in WHERE doesn't work
- by Gainder
Hello, I have created a simple static function in oracle 10g to get the reference of an object based on his pk. STATIC FUNCTION getRef(nome IN VARCHAR2) RETURN REF folder_typ IS fl_r REF folder_typ := null; BEGIN SELECT REF(fl) INTO fl_r FROM folder_tab fl WHERE…Read the article
-
Errors with large data sources
- by The Sheek Geek
I'm doing some benchmarking on large data sources and binding/exporting data for reporting. I started with using a data set, filling it with 100000 rows and then attempting to open a crystal report with the retrieved data. I noticed that the data set filled just fine (took about 779…Read the article
