I want to call create table/ alter table command from a procedure. Is it possible? My requirement is to change the datatype of a column in all tables.So, 开发者_如何转开发 I am just getting the colum
I have a problem in my asp.net MVC application. I have a wrapper class for PL/SQL package. And I have to save screen changes to database through package call. While the process its not throwing any e
I\'ve some prob with the function TABLE in ORACLE. SET SERVEROUTPUT ON SIZE 100000; DECLARE int_position NUMBER(20);
I need to generate unique and consecutive numbers (for use on an invoice), in a fast and reliable way. I currently use an Oracle sequence, but in some cases, the generated numbers are not consecutive
Is it a bad practice to do what the code below does? Will b开发者_JAVA技巧ad things happen to me for writing it?
I have a SQL script that is being executed in TOAD.Currently, I have it laid ou开发者_开发技巧t with just statement after statement, thusly:
i created a procedu开发者_如何学Cre with 32 in argument,it sucessfully created.but when i am executing this in back end oracle the errror came ORA:00900 Invalid sql statementUse:
It so happens that I have to get a date from a varchar2 column in oracle, but it is inconsistent in formatting. Some fields might have \'2009.12.31\', others \'2009/12/32 00:00:00\'. Is there any stan
I want to write a PLSQL stored procedure that accepts a table name as argument.This table is source table.Now inside my procedure i want to manipulate the fields o开发者_StackOverflow中文版f that tabl
I am having problem with importing csv files containing values in japanese characters. When I do so it will display garbage when I query. my OS is japanese. My encoding for oracle NLS_LANG is JAPANESE
加载中,请稍侯......