PL/SQL :: How To Make Default For Nchar
Aug 3, 2013I want to make default 'y' for COL1 how should i make it.1) "COL1" NCHAR(10) DEFAULT N'y'or 2) "COL1" NCHAR(10) DEFAULT 'y' yours sincerly
View 5 Replies
ADVERTISEMENT
Application Express :: How To Make Default Attachment As CSV File Instead Of HTM
Oct 28, 2012I am having an interactive report with an email subscription.
My question is, how can I make the default attachment as a .csv file instead of the .htm file?
PL/SQL :: NLS-NCHAR-CHARACTER-SET Not Working?
Sep 12, 2013My database has following NLS Charatset settings. NLS_ CHARACTERSETUS7ASCIINLS_ NCHAR_CHARACTERSETAL16UTF16 I have a table create table test_tbd(a varchar2(2000), b nvarchar2(2000)); but when i insert following values using sqldeveloper
Insert Into Test_Tbd Values ('España','España'); And trying to select them following is the outputEspa�aEspa�a me with NVARCHAR2 issue.
ORA-12713 - Character Data Loss In NCHAR / CHAR Conversion?
Apr 4, 2011got this Errormessage "ORA-12713: Character data loss in NCHAR/CHAR conversion" during a rman backupjob! How can I fixed it?
View 3 Replies View RelatedSQL & PL/SQL :: Default Values / Distinguishing Between Passed And Default Nulls
Nov 16, 2010I was looking for a way to see if a default value for a procedure was passed NULL or it got NULL by default. [URL]
View 11 Replies View RelatedSQL & PL/SQL :: How To Use Default Value
Feb 21, 2013I want to use default value in pl/sql , i'm executing below code
SET serveroutput ON
DECLARE
l_deptno INTEGER DEFAULT 10;
v_dname VARCHAR2(200);
[Code]...
SQL> @test.sql
Enter value for deptno: 40
dname value=OPERATIONS
I tried with NULL to use its default value but it uses NULL(which does make sense)
SQL> @test.sql
Enter value for deptno:
error
How to use the default value of the passed argument?
expected O/P
dname value=ACCOUNTING
DEFAULT Value On Columns?
Mar 24, 2011I wanted to know the consequences of adding a DEFAULT value to an existing column in a table.I understand that when you add a DEFAULT value to a column which is Nullable, Oracle updates all the null values for the column to the DEFAULT value, generating a lot of undo/redo data.
Is adding a DEFAULT value to a NOT NULL column a problem? As the column is NOT NULL, an update would not be done, so no undo/redo data will be generated.But will this cause a whole table scan? Is this advisable?
SQL & PL/SQL :: Default Value Is Sysdate
Nov 4, 2011During the Table Creation if it possible to Use the SYSDATE is Default Value for a Column.
View 3 Replies View RelatedXE :: Map Default Apex URL
Mar 27, 2013I'm using apex 4.2 with Weblogic server. Right now our url to the application is
[URL].......
How can we make it much more simpler like
[URL].......
SQL & PL/SQL :: How To Make PK Not To Validate
Nov 21, 2011i am writing a script for inserting rows in a table where primary key of that table consists of 4 columns. I want to add a new row where 3 columns of that table will be same but change the value of the last one. this is giving an error saying that i am violating the unique constraint. I tried to disable that constraint/PK by following statement but still this error is coming
alter table sections_budgets modify primary key disable cascade;
OR
alter table sections_budgets modify constraints sec_bdgt_pk disable cascade;
the insert statement which i am using. The first four columns are part of PK
insert into sections_budgets (SELECT sb.bdgt_cd, sb.bdgt_dpf_cd, sb.bdgt_yr, :sec_code, sb.usf_usr_id,
sb.aty, sb.comaty, sb.comytd, sb.expn_ytd, sb.sys_dt, sb.cat,
sb.start_aty, sb.expn_lmt
FROM sections_budgets sb
WHERE sb.bdgt_dpf_cd = :b_d_code AND sb.bdgt_yr = :year);
is there any other way of inserting records in this table without droping the whole table because it contains too many triggers and constraints?
SQL & PL/SQL :: How To Make Report
May 2, 2010How can I make report in below format ?
Month Apr-09 May-09 Jun-09 ...... Mar-10 Total
Basic 1000.00 1100.00 1300.00 ...... 1300.00 13260.00
HRA 500.00 600.00 650.00 ...... 600.00 6350.00
Conveyance 100.00 200.00 300.00 ...... 350.00 1300.00
Gross Amt 12350.00 13500.00 13200.00 ......14500.00 23456.00
Adding Column With Default Value?
Jul 11, 2007how do I add a column to an existing table which when rows are added to the table this column will have the same default value?
alter table thetable add (new_column_name varchar2(100) default bbubu);
SQL & PL/SQL :: Set Default Value For A Column Of Table
Aug 30, 2010How to set default value of particular column of a table ?
View 5 Replies View RelatedForms :: How To Default Where Condition
Nov 2, 2011I am working on forms 6i. I have set where condition in pre-query of a trigger, my requirement is, in post-query, i want to delete the where condition.
pre-query:
set_block_property('HEADER_S',default_where,'STATUS IN (select meaning from XXSMCQSS_LOOKUP_VALUES where lookup_type=''CONCESSION STATUS CODES'' and primary_flag=''N'' )');
post_query: I want to delete this where condition, i just want make execute query normal by removing the where condition.
SQL & PL/SQL :: Eliminate Default Time 12:00 Am
May 10, 2012I have a table with Date Field . While selecting the records its display like below format.
TO_CHAR(CHAR_DATE,'DD-MM-RRRRHH:MI:SSAM')
10-05-2012 12:00:00 AM
10-05-2012 03:26:16 PM
1 row doesnt have time, but in default it shows 12:00:00 AM, how to eliminate it. Display should be
10-05-2012
10-05-2012 03:26:16 PM
create table time_test (char_date date);
INSERT INTO TIME_TEST ( CHAR_DATE ) VALUES (
TO_Date( '05/10/2012', 'MM/DD/YYYY HH:MI:SS AM'));
INSERT INTO TIME_TEST ( CHAR_DATE ) VALUES (
TO_Date( '05/10/2012 03:26:16 PM', 'MM/DD/YYYY HH:MI:SS AM'));
COMMIT;
select TO_char(CHAR_DATE,'dd-mm-rrrr HH:MI:SS AM') from time_test;
i need in to_char only, im using it in reports
SQL & PL/SQL :: Why Are Foreign Key Not Deferral By Default
Apr 18, 2013In my point of view, deferral FK (DFK) are stronger than non-deferral FK (NDFK). In other words, every NDFK can be moved to DFK. Is there a performance issue ?
View 2 Replies View RelatedSQL & PL/SQL :: By Default Buffer Size?
Apr 30, 2013What is By Default Buffer size in Oracle ......?
View 4 Replies View RelatedDefault Oracle Users
Oct 2, 2013I am trying to find out if there is a definite way to find out (by querying database) which database users have been created by Oracle (either during installation or as part of patching or adding new feature) and which database users have been created by DBAs.
I have looked into the documentation but could not find anything relevant. Ideally, I would like to know if this can be done for any versions starting from 9iR2.
PL/SQL :: How To Set The Default Long Datatype
Jul 12, 2013Query that I want to run:
exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES', false);
result: E;;45;45 ;45 ;45 ;S 45
I am not sure but may be I need to set long size before running above query. But when I try to set long size gives below error. "The output from DBMS_METADATA.GET_DDL is a LONG datatype. When using SQL*Plus, your output may be truncated by default. Issue the following SQL*Plus command before issuing the
DBMS_METADATA.GET_DDL statement to ensure that your output is not truncated:"SQL> SET LONG 9999error: Unhandled SET statement: "SET LONG 9999"
Database Encryption By Default
Aug 10, 2010I would like to know the reason why the database is on unencrypted format by default,there must be some reason behind this, i hear from someone that encrypted data degrade performance thats the reasons its on unencrypted format by default.
View 6 Replies View RelatedSQL & PL/SQL :: Procedure With Default Columns
Apr 27, 2010 I have the following procedure...
CREATE OR REPLACE Procedure Updatetdef_normal_ranges (
i_tdef_range_id in number,
i_user_change_id in number default -1,
i_norm_range_low in number default NULL,
[Code]....
EXCEPTION
WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END Updatetdef_normal_ranges;
I am trying to execute it using the command
Execute Updatetdef_normal_ranges (i_tdef_range_id => 1, i_norn_range_high => 100.34, i_high_reflex_tdef_id => 100, i_low_reflex_tdef_id => 17, i_range_low_sched => -1)
and I am getting the following error...
SQL> Execute Updatetdef_normal_ranges (i_tdef_range_id => 1, i_norn_range_high => 100.34, i_high_reflex_tdef_id => 100, i_low_reflex_tdef_id => 17, i_range_low_sched => -1);
BEGIN Updatetdef_normal_ranges (i_tdef_range_id => 1, i_norn_range_high => 100.34, i_high_reflex_tdef_id => 100, i_low_reflex_tdef_id => 17, i_range_low_sched => -1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'UPDATETDEF_NORMAL_RANGES'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
If I replace the update statement with dbms_output statement this procedure works fine.
How To Make Sure Checkbox Checked Or Not
Apr 19, 2007On a page I have let's say 5 rows (can be more or less) and each row ends with a checkbox. On the next page(next prcodure) I go through all rows, but I get a "No data found" when a checkbox is not checked. Checkbox's parametre is send using an array.How can I make sure is a checkbox checked or not. If it's not, I put a formHidden through in it's place?
View 1 Replies View RelatedHow To Make Multiple Inserts In DB
Sep 4, 2009i have multiple inserts to make in a table that is in an Oracle database...i already try several ways to do it but it always giving erros... how to make multiple inserts at same time.
View 2 Replies View RelatedSQL & PL/SQL :: How To Make Horizontal Partitioning
Mar 4, 2013how should i do to make horizontal partitioning?
View 18 Replies View RelatedSQL & PL/SQL :: How To Make Columns Out Of Records
Feb 8, 2013I want to learn how to make columns out of records?
View 8 Replies View RelatedSQL & PL/SQL :: How To Make A Call To A Proc
Mar 24, 2010How to make a call to a proc and immediately return without waiting for the called proc to end.
Nothing I try seems to do the trick...The calling program always has to wait.
Forms :: How To Make A Calendar
Mar 4, 2003I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?
View 20 Replies View RelatedForms :: How To Make A Node
Feb 27, 2012How to make a node of a Hierarchical Tree BOLD without intervene java code ?
View 1 Replies View RelatedSQL & PL/SQL :: Make A Trigger That Don't Allow Delete?
Jun 11, 2013Well I need to make a trigger that don't allow delete departments in the next 3 month.
I dont know how to start it :/
Make Some Rows As A Read Only?
Jan 8, 2013Oracle Version 11.2.0.1
Windows
There are some tables in a schema. How can I make some rows as a read only i.e. no user can make either any update nor delete them. After searching in google, I found that trigger is one way, but since this way can be manipulated by dropping or renaming the trigger, so I am looking non-trigger way to achieve this problem. Making tablespace read only affects other users. I am not looking whole table as a read only, just couple of rows should be locked (no DML allowed) for specific time period and I after specific time/date this restriction should auto disable or on user call i.e. something like row's block level locking..