Oracle Help
in [SQL]
|
sql loader how to escape double quotes Hi all, I would like to know how it is possible to escape double quotes in a format string in the control file. I explain the problem. I have a table with 2 columns CREATE TABLE MARCO ( TYPE VARCHAR2(3 BYTE) NULL, START TIMESTAMP(6) NOT NULL ) in the data file there i... 26 Aug 2008 11:57
NUP license There are 60 Named User Plus licenses for Oracle Enterprise Edition 11g in the company. All these users use a production instance on a server with 1 processor. We are not sure if we need additional licenses in these cases: 1. If we add a second production instance, do we need to buy addition named user plus lice... 26 Aug 2008 17:07
Excellent website for ORACLE exams Excellent website for ORACLE exams http://certadvisor.blogspot.com Best of luck. ... 24 Aug 2008 11:53
DECODE QuestionHi, Hi, I have a question about DECODE. I know that I can return a 1 or 0 using DECODE: SELECT (DECODE...,1,0) FROM <table name> WHERE........; My question is, what you need to just decode the result of the where? Basically if all the criteria of the WHERE statement is true, return a 1, and if any of the crite... 22 Aug 2008 14:02
Question about DECODE Hi, I have a question about DECODE. I know that I can return a 1 or 0 using DECODE: SELECT (DECODE...,1,0) FROM <table name> WHERE........; My question is, what you need to just decode the result of the where? Basically if all the criteria of the WHERE statement is true, return a 1, and if any of the cri... 23 Aug 2008 00:16
Oracle Client for 32 bit and 64 bit coexist Dear Experts, We met an issue with Oracle client, and hope you could give us some advice. On our Windows 2003 64 bit servers, currently we have Oracle Client 32 bit installed using by an application. However, running our MS.NET programs on x64 Windows require Oracle client for 64 bit installed. Otherwise, an ... 26 Aug 2008 18:09
how to suppress query output in the command window? Dear Oracle users: I have a very simple test.sql file shown below: ============ set echo off set feedback off spool C:\test.log select* from dbname.tablename / spool off exit ============== When I submitted in Windows command window as the following: C:\>sqlplus loginname/password(a)dbname @test.sq... 21 Aug 2008 20:40
best way to "parameterize" a tablename? I have need to do something like this: if tablename = 'FOO' insert into foo ... else if tablename = 'BAR' insert into bar ... (exact same stuff) etc... I hesitate to use an execute immediate, due to the troublesome quoting issues, but is there a good way to do something like th... 25 Aug 2008 03:12
how to clone a table? I have a table MASTER_DEF_TBL and would like to replicate its definition (including constraints, indexes, comments, etc) to several tables such as MY_DEF_TBL and YOUR_DEF_TBL. What's the best way to do this? Is there a table clone command, or some way to inherit from another table? Many TIA! Mark -- Mar... 24 Aug 2008 17:00
NUMBER(0) and NUMBER Hello, what does the datatype NUMBER(0) mean? Is it the same as NUMBER, which can be seen in turn as FLOAT? Thank you, Norbert ... 19 Aug 2008 13:13 |