sql - Do we need to delete the constraints when we mark some table columns as unused? -


there couple of columns have constraints on them. setting these columns unused. should dropping constraints?

you can drop constraints if want, there's no rule saying have to.

if end later dropping columns, constraints dropped automatically anyway.


Comments

Post a Comment

Popular posts from this blog

bash - How do you programmatically add a bats test? -

i'd have bats test created every file in directory, i'm not sure best way done is. approach below creates single test when there many files in directory. #!/usr/bin/env bats in $(ls) @test "testing $i" { pwd } done to extract ls output not batter solution go wrong on filenames spaces. you can below shopt -s nullglob file in /dir/* //test command on $file done shopt -u nullglob you can using find command also find /some/directory -maxdepth 1 -type f -exec cmd option {} \;
Read more

Unable to open serial port using Putty to bluetooth device on windows 7 64 bit -

i working on dell windows 7 pro 64 bit machine. trying use on board bluetooth adapter comm homegrown bluetooth device using putty , serial port... device pairs computer. hoever, putty unable open serial port bluetooth device mapped/assigned to. tried putty 0.60 , 0.63. suggestions/help appreciated. thanks! pertinent details: baud: 57600 port: outgoing: com3 'spp dev' incoming: com4 adapter: intel wireless bluetooth adapter 4.0 has called microsoft bluetooth enumerator... putty version 0.60: 57600 com3 8 bits 1 stop bit no parity xon/xoff line discipline options: force on , force on putty version 0.63: 57600 com3 8 bits 1 stop bit no parity xon/xoff line discipline options: force on , force on when run putty 0.63, notice ssh selected connection type on right panel. have tried changing serial , updating com port configuration?
Read more

java - Getting exception in JDBC thin driver -

i try run query using java , below mentioned program import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.statement; import javax.naming.spi.dirstatefactory.result; public class oracleconn { public static void main(string[] args) { try { class.forname("oracle.jdbc.driver.oracledriver"); connection con = drivermanager.getconnection("jdbc:oracle:thin:@localhost:1521:yglobal","user","user"); statement stmt = con.createstatement(); resultset rs = stmt.executequery("select empid empmaster"); while(rs.next()) system.out.println(rs.getint(1)); con.close(); } catch (exception e) { e.printstacktrace(); }} } but when tried run program getting exception java.sql.sqlexception: ora-01756: quoted string not terminated @ oracle.jdbc.driver.databasee...
Read more