`
jsntghf
  • 浏览: 2481107 次
  • 性别: Icon_minigender_1
  • 来自: 苏州
社区版块
存档分类
最新评论

set define off

阅读更多

通过sql向oracle数据库导入数据时,提示输入nbsp的值,原来导入内容中包含了 ,sqlplus把&作为一个变量的开头,所以每次执行这条语句时会提醒你输入相应的值。

 

可以通过set define off关闭该功能,&将作为普通字符处理。


set define off 关闭替代变量功能
set define on 开启替代变量功能
set define *  将默认替代变量标志符改为*

分享到:
评论

相关推荐

    Oracle中插入特殊字符:和的解决方法汇总

    今天在导入一批数据到Oracle时,碰到了这样一个问题:Toad提示要给一个自定义变量AMP赋值,一开始我很纳闷,...方法一:在要插入的SQL语句前加上Set define off;与原SQL语句一起批量执行 我们在SQL*PLUS下执行 SQL> sho

    dsp28335LCD程序

    #define DISPLAY_OFF 0x08 //显示关 #define CURSE_DIR 0x14 //游标向右移动:AC=AC+1 #define SET_CG_AC 0x40 //设置AC,范围为:00H~3FH #define SET_DD_AC 0x80 extern uchar A[]={"南京研旭"}; extern ...

    8192CU LINUX驱动

    //#define CONFIG_SET_SCAN_DENY_TIMER #define CONFIG_LONG_DELAY_ISSUE #define CONFIG_NEW_SIGNAL_STAT_PROCESS //#define CONFIG_SIGNAL_DISPLAY_DBM //display RX signal with dbm #ifdef CONFIG_IOL #define...

    EPM240 CPLD最小系统串口开发板PDF原理图+Verilog测试Quartus工程源码.zip

    EPM240 CPLD最小系统串口开发板PDF原理图+Verilog测试Quartus工程源码,模块上电蜂鸣器响一声,3个LED灯闪烁 串口数据通信协议: 1、接收【控制32路GPIO输】 55 F1 01 (00-1F) FF 32路...`define CLOCK_FACTOR 16

    ili932x系列驱动程序

    #define Lcd_Light_OFF GPIO_ResetBits(GPIOA,GPIO_Pin_3); #define DataToWrite(PORTE) (*((volatile unsigned long *) 0x4001180C) = PORTE) #define Set_nWr (*((volatile unsigned long *) 0x40011410) = ...

    T6 5.1升级T66.2报错

    SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[IA_Subsidiary] Script Date: 06/12/2014 14:09:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo]....

    mysql-5.5.43.tar.gz

    # respect user wishes and do not (re)define CMAKE_BUILD_TYPE. If WITH_DEBUG{_FULL} # is given, set CMAKE_BUILD_TYPE = Debug. Otherwise, use Relwithdebinfo. IF(DEFINED CMAKE_BUILD_TYPE) SET(HAVE_...

    仙童0165电源芯片

    void SetOnOff(uchar onoff); //开关显示 void SelectScreen(uchar screen);//选择屏幕 void ClearScreen(uchar screen); //清屏 void Show1616(uchar lin,uchar colum,uchar *address);//显示一个汉字 void ...

    IgH EtherCAT master-ethercatpack.7z

    int interpolation_2_ecat_set_slave_pwr_off(MasterSpecifiedInfo_T *master_specified_info, int slave_pos); 中slave_pos参数就对应不同的轴,slave_pos=0,axis1 slave_pos=1,axis2... (2)设置不同轴的操作...

    ANSI-VITA 62-2016 Modular Power Supply Standard.pdf

    vendor, requiring them to define what has, at times, been seen as a form of “black art.” This standard, however, defines a set of rules by which industry power supply vendors can build COTS products...

    lcd显示程序

    #define uint unsigned int //定义一下方便使用 #define uchar unsigned char //定义一下方便使用 #define DATA P0 //LCD12864数据线 sbit RS=P2^2; // 数据\指令 D、I 选择 sbit RW=P2^1; // 读\写 选择 R、W sbit ...

    uboott移植实验手册及技术文档

    #define __REGb(x) (*(volatile unsigned char *)(x)) #define __REGi(x) (*(volatile unsigned int *)(x)) #define NF_BASE 0x4e000000 # if defined(CONFIG_S3C2410) #define NFCONF __REGi(NF_BASE + 0x0) #...

    !!!!ap6212a0_a33_sc3817r_验证通过_修正wifi的配置文件为nvram_ap6212.txt

    [ 3.968638] [mmc]: sdc2 set ios: clk 25000000Hz bm PP pm ON vdd 3.3V width 1 timing LEGACY(SDR12) dt B [ 3.968734] [mmc]: mclk 0xf1c20090 0xc100000b [ 3.989421] Bluetooth: BNEP filters: protocol ...

    pt7c4307 驱动

    static int rtc_read_proc(char *page, char **start, off_t off, int count, int *eof, void *data) { char *p = page; int len; struct rtc_time tm; read_time(&tm); //printk("RTC ... %d\n",xtime.tv_...

    MSP430HS0038控制程序

    BCSCTL1 &= ~XT2OFF; do { IFG1 &= ~OFIFG; for(i=0xff;i>0;i--); } while((IFG1&OFIFG;)!=0); BCSCTL2 |= SELM_2; //MCLK ---8MHz BCSCTL2 |= SELS+DIVS_3; //SMCLK --- 1MHz for(i=0Xff;i>0;i--); //P5...

    php.ini-development

    They can be turned off using the values 0, Off, False or No. ; An empty string can be denoted by simply not writing anything after the equal ; sign, or by using the None keyword: ; foo = ; sets foo...

    12864显示的万年历

    #define LCD_OFF 0x3E #define LCD_ON 0x3F #define Add_X 0xB8 //the start address of the page 0 ;(0~7) #define Add_Y 0x40 //the start address of the Y counter ; (0~64) #define Add_Z 0xC0 //the start ...

    ds18b20(液晶显示12864)

    #define SETBIT(x,y) (x|=(1)) //set bit y in byte x #define CLRBIT(x,y) (x&=(~(1))) //clear bit y in byte x #define CHKBIT(x,y) (x&(1)) //check bit y in byte x /****************************************...

    黄炎培介绍

    #define RS_SET P5OUT|=BIT6 #define RW_CLR P5OUT&=~BIT5 #define RW_SET P5OUT|=BIT5 #define EN_CLR P5OUT&=~BIT4 #define EN_SET P5OUT|=BIT4 #define cs1_CLR P5OUT&=~BIT1 #define cs1_SET P5OUT|=BIT1 #...

    thl_r16_tinav2.0_hm1375验证通过_增加打印设备ID_20170824_1447.7z

    if(dev->vip_define_sensor_list == 1) { if(dev->ccm_cfg[input_num]->sensor_cfg_ini->power_settings_enable == 1) { cpy_ccm_power_settings(dev->ccm_cfg[input_num]); } } #ifdef _...

Global site tag (gtag.js) - Google Analytics