Oracle Help
in [SQL]
|
if I call a plsql is there a commit? Hi, excuse me for the simplicity of the question but I'm a beginner.. I have seen somethings similar in this forum. If i have a procedure plsql that calls an other one like this: CREATE OR REPLACE PROCEDURE p1 as begin p2(); p3(); .... end; After p2 is there a commit or it is after end? Thanks in a... 12 Mar 2006 17:10
Interval data... Hi! Given an interval, how can I identify the first and last dates/times of it? I had a look at the doc but there isn't much there for this. Lots of Greetings1 Volker ... 22 Feb 2006 14:49
Sysdate Value Hi All I want to know how exactly 'select sysdate from dual' works. From where Oracle brings in sysdate if the init parameter fixed_date do not have any value set against it. I know it brings the server machine date time and if it does then exactly how is sysdate pointed to bring in server time when Oracle is in... 23 Jan 2006 12:10
help for execute immediate hi i am writing a new stored procedure. the error i am gettin g is i have a variable whereclause in this i have an and clause as whereclause := ' AND usr.act_key IN (SELECT DISTINCT act2.act_key FROM' || ' act act2, aad, usg, ugp, usr usr5' || ... 22 Jan 2006 16:56
Oracle SQL Date Calculations? Hi, just like to have some quick command reference. By the following command: select to_date('20051231','YYYYMMDD') - to_date('20051101','YYYYMMDD') from dual; we can get the difference between the two dates are 60 days. By using add_months() we can get the month from given difference. Are there more su... 13 Jan 2006 14:33
optimizer_secure_view_merging Hello, there is a new initialization parameter OPTIMIZER_SECURE_VIEW_MERGING in oracle 10gR2. The documentation says: OPTIMIZER_SECURE_VIEW_MERGING allows you to enable or disable view merging globally for the database. Can somebody give me a simple example (sqlplus) how the parameter works? Thank you! Regard... 13 Jan 2006 11:24
please help me with some cheat sheets Hi Im A unix admin, now asked to support oracle DB server administration, can any one please please help me with some good docs and CHEAT SHEETS. As a trade off I can share some of my unix administration and SAN and veritas cheat sheets. Thanks vxdiskadm(a)gmail.com ... 10 Jan 2006 14:30
ORA-01779, update join view Hi there, I'm trying to solve an update, and simply can't find a way. It updates 1 table, that has a 3 column PK. See it here: update ( select t1.emp_cod t1emp, t1.cednte_cedn t1cedn, t1.titlo_noss_num t1noss, t1.titlo_num_versao, t2.emp_cod t2emp, t2.cednte_cedn t2cedn, t2.titlo_noss_num t2noss, t2.ren... 29 Dec 2005 08:00
ORA-06512 ORA-20001: ORA-20100: Error on Line CREATE VIEW BRESDATA AS SELECT JRULES_BRESDATA.JRules_Bresdata_Id ID, JRULES_BRESDATA.Ruleapp_Name, JRULES_BRESDATA.Ruleapp_Major_Version, JRULES_BRESDATA.Ruleapp_Minor_Version, JRULES_BRESDATA.Rulese ORA-06512: at line 2189 Can anyone explain the meaning of the ORA-06512 er... 4 Oct 2005 09:22
varchar Vs. varchar2 Vs. nvarchar Hi All, I need to know the difference between varchar and varchar2 and nvarchar. I want to develop an application that should be unicode complaint. So, I am ambiguous about using nvarchar OR varchar2. As I have understood, nvarchar supports multi lingual text. But, varchar2 also supports (I have seen databases t... 4 Oct 2005 06:09 |