1. Change the table name and field name to uppercase see-http://www.cnblogs.com/wenboge/articles/4121331.html2. Change the table name and field name to lowercase① change table name to lowercasebegin forCinch(SelectTABLE_NAME TN fromUser_tableswheretable_name Lower(table_name)) Loopbegin ExecuteImmediate'ALTER TABLE'||C.tn||'Rename to "'||Lower(c.tn)||'"'; Exception whenOthers ThenDbms_output.put_line (c.tn||'already exists'); End; EndLoop;End;② field is named lowercasebegin forT
--oracle See all of the user's table names, table comments, field names, field comments, empty, field type SELECT DISTINCT table_column.*, table_nallable. Data_type, table_nallable. NULLABLE from (SELECT DISTINCT Utc.table_name table_name, utc.comments table_comments, Ucc.column_name column_name, ucc.comments column_comments from User_tab _comments UTC, User_col_comments UCC where utc
ORACLE cannot use variables as column names and table names some of the individual validations are:1 DECLARE2Ename1 Emp.ename%TYPE;3TYPE Index_emp_type is TABLE of VARCHAR2( -)INDEX byPls_integer;4 index_emp Index_emp_type;5 BEGIN 6Index_emp (1) := 'E.ename';7 SELECTIndex_emp (1) intoEname1 fromEMP EWHEREE.empno=7369;8 EXECUTEIMMEDIATE'Select' ||Index_emp (1)|| 'From emp e where e.empno=7369' intoename1;
Often encountered some forget the table name situation, at this time only remember a approximate, at this time can be queried by the system table sysobjects to find the table name, such as to find the name of the table containing the user, can be implemented by the following SQL statement,Select *From sysobjectsWhere name like '%user% 'If you know the column name and want to find the name of the table that contains the column, you can add the system table syscolumns, and if you want to find all
purpose of the command is very extensive, above just the pointer file name and directory name of the naming characteristics to extract some special cases. ii. basename and DirName ${} is not a command specifically designed to extract filenames and directory names, so the basename and DirName commands are specifically prepared for this.1, basenameThe purpose of this command is to extract the file name from the path, using the basename name [SUFFIX].
Get table names and comments:Select Relname as Tabname,cast (obj_description (Relfilenode, ' pg_class ') as varchar) as comment from Pg_class Cwhere relkind = ' R ' and Relname not-like ' pg_% ' and relname not-like ' sql_% ' ORDER by RelnameFilter out the Sub-table:Conditional and relchecks=0 can beGets the field name, type, comment, whether it is empty:SELECT col_description (A.attrelid,a.attnum) as Comment,format_type (A.atttypid,a.atttypmod) as ty
One day when writing classes suddenly thought of this problem, the following to explain how to solve the problem.Define a class:class test{public: void setnum (); void getnum (); Private : int num;}; void Test::setnum () { ten;} void Test::getnum () { printf ("%d\n", num);}Run:int Main () { test one; One.setnum (); One.getnum (); return 0 ;}Console output 100, which indicates that member functions can be directly modified by the member variables wit
This article describes how Python traverses directories and replaces file names and directory names in batches. Share to everyone for your reference, specific as follows:
#encoding =utf-8 #author: Walker #date: 2014-03-07 #summary: Depth traverse the specified directory and change the subdirectory and file name to lowercase #注意, this program is only for Windows, Windows file (folder) name is case-inse
Tags: select databaseUpdate Dept B, (select Group_concat (T.deptid), Group_concat (d.deptname separator '/') as Dname, T.id, t.deptname from (sel ECT Substring_index (Substring_index (A.deptid, ', ', b.help_topic_id+1), ', ', -1) as DeptID, a.ID, A.deptname from (select D.father as DeptID, D.id, D.deptname from Dept D) a join Mysql.help_topic B on b.help_topic_id GROUP by ID, deptname) C set b.location=c.dname where b.id = C.idEffectCopyright NOTICE: This article for Bo Master original article,
, the whole server may not be able to withstand it, let alone the virtual host.A fatal drawback of the free blog service is that the website actually does not belong to the blog author, which is extremely dangerous on the Internet. Only by using your own domain name to build your own blog website can the author have ownership and control of this
://www.CodeHighlighter.com/-->Websites support pan resolution to access websites such as: http://cyq1162.cyqdata.com equivalent to http://www.cyqdata.com/cyq1162
At the same time support the use of level 2 Use blog such as: http://blog.cyqdata.com/cyq1162
For this support, only one configuration file is required:
5. Sub-directory support: All Sub-directories can be run in [virtual directories ].
Note:
Code highlighting produced by Actipro CodeHigh
space... When you have space, you can upload the home page file you have created to this file, which can be viewed by others... You can apply for a space on another website... There is also a space to sell... You have to pay for it in one year...How to Create a blog of your own?
Blog: all major websites now provide blogs for registered members, such as Baidu, Sina, and Netease. Such blogs only need to regi
Recommend blog rules
All users of the csdn Blog have the opportunity to recommend their blog posts to the homepage of the blog channel. When posting a blog, select "publish to the csdn blog homepage.
User recommendation requ
correct. You need to create the crawler file by yourself. In this directory, create a botspider. in this example, the crawler class defined in this example is inherited from the crawler class.
To define a Spider, the following variables and methods are required:
Name: defines the spider name. This name should be unique and must be used when executing this crawler.
Allowed_domains: List of domain names that can be crawled. For example, if you want to
If you have any concerns about Han's Sina Weibo (or other Korean micro-blogs), you will find that almost all of the Korean humble Bo information, mainly from his blog in the form of long microblogging forwarded to the microblog. In this way, Han let their influence further expansion-compared with the articles published on the blog, Han is published to micro-bo long micro-bo every time in a short period of t
Spring-Blog: personal Blog (1)-Mybatis read/write splitting,Overview:
2018After a period of time in Ping (tou) Jing (lan), I began to find something to do. This time, I plan to develop a personal blog and complete my own technologies during the development process. This series of blogs only propose some valuable technical ideas and do not record the development
Use blog to improve Google ranking
Two of the most popular songs in the music industry some time ago: "mouse loves rice" and "two butterflies". In the baidu search rankings, the search volume of these two keywords increases every day, although Google does not have a list of popular keywords, it can be inferred that the daily search volume is more than 0.1 million. However, if you search for these two keywords on Google, it will surprise you, the homep
A simple blog system instance based on CakePHP and a cakephp blog instance. A simple blog system instance based on CakePHP. a cakephp blog instance is a simple blog system based on CakePHP. Share it with you for your reference. The specific implementation method is based on
Recently, I am confused about csdn's blog point calculation rules. I have seen a csdn blog titled how to calculate csdn's blog points: "ranking score of the blog ranking = sum of all essays on the personal blog and the number of readings on the article + sum of all comments
Back to directory creation service
Create a new service file
Ng G Service Blog/note-service
We can refer to Shared\service-proxies\ Service-proxies.ts file to write our service files, which is provided by the template, look at the top of the introduction, said to be automatically generated with the Nswag, bloggers are now not use this tool, there are ways to use please advise.
Let's get back to the backend API address.
API domain name
const Apihost
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.