You could execute the `.sql` file as a script in the **SQL Developer** worksheet. Either use the **Run Script** icon, or simply press &lt;kbd&gt;F5&lt;/kbd&gt;.

[![enter image description here][1]][2]

For example,

    @path\script.sql;

Remember, you need to put `@` as shown above.

But, if you have exported the database using database export utility of SQL Developer, then you should use the Import utility. Follow the steps mentioned here [Importing and Exporting using the Oracle SQL Developer 3.0][3] 


  [1]: http://i.stack.imgur.com/NJ9ST.jpg
  [2]: http://i.stack.imgur.com/NJ9ST.jpg
  [3]: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLdev3.0_Import_Export/sqldev3.0_import_export.htm

You need to Open the SQL Developer first and then click on **File** option and browse to the location where your .sql is placed. Once you are at the location where file is placed double click on it, this will get the file open in SQL Developer. Now select all of the content of file **(CTRL + A)** and press **F9** key. Just make sure there is a commit statement at the end of the .sql script so that the changes are persisted in the database

As others recommend, you can use Oracle SQL Developer. You can point to the location of the script to run it, as described. A slightly simpler method, though, is to just use drag-and-drop:

 - Click and drag your .sql file over to Oracle SQL Developer
 - The contents will appear in a &quot;SQL Worksheet&quot;
 - Click &quot;Run Script&quot; button, or hit &lt;kbd&gt;F5&lt;/kbd&gt;, to run

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/s7pfW.jpg

You can use Load function

    Load TableName fullfilepath; 

Managed to store my files in a folder but they store without the file extension.

Does any one know how would I store the file with file extension?

How to store a file with file extension with multer?

I&#39;m trying to create a small window manager (just for fun), but I&#39;m having problems in handling windows created by Firefox (only with that application, other apps works fine) 

The problem is, after I launch Firefox, and add my decoration, it seems to work fine, but if for example I try to click on the menu button, the (sub)window doesn&#39;t appear. 

What seems to happen is that after the click, a ClientMessage event is fired with the following values:

    Data: (null)
    Data: _NET_WM_STATE_HIDDEN
    Data: (null)
    Data: (null)
    Data: (null)



Now the problem is that I don&#39;t know how to show the window, which window. 
I tried with: 

* XRaiseWindow
* XMapWindow
* I tried to get the transient window and show it

But without success. What I don&#39;t understand is that if this client message is generated by the menu subwindow or not. 

How should I show a window that is in _NET_WM_STATE_HIDDEN?

Another strange problem is that after receiving the ClientMessage, I always receive 2 UnMapNotify Events. 

I also have another question, if I want to show the &quot;File, Edit&quot; men&#249; (in Firefox it appears, if I remember correctly, when you press the Alt button. 

Maybe Firefox creates a tree of windows?

This is the loop where I handle the events: 

    while(1){
    	XNextEvent(display, &amp;local_event);
    	switch(local_event.type){
    		case ConfigureNotify:
    			configure_notify_handler(local_event, display);
    		break;
    		case MotionNotify:
    			motion_handler(local_event, display);
    		break;
    		case CreateNotify:
    			cur_win = local_event.xcreatewindow.window;
    			char *window_name;
    			XFetchName(display, cur_win, &amp;window_name);
    			printf(&quot;Window name: %s\n&quot;, window_name);
    			if(window_name!=NULL){
    				if(!strcmp(window_name, &quot;Parent&quot;)){
    					printf(&quot;Adding borders\n&quot;);
    					XSetWindowBorderWidth(display, cur_win, BORDER_WIDTH);
    				}
    				XFree(window_name);
    			}
    		break;
    		case MapNotify:
    			map_notify_handler(local_event,display, infos);
    		break;
    		case UnmapNotify: 
    			printf(&quot;UnMapNotify\n&quot;);
    		break;
    		case DestroyNotify:
    			printf(&quot;Destroy Event\n&quot;);
    			destroy_notify_handler(local_event,display);
    		break;
    		case ButtonPress:
    			printf(&quot;Event button pressed\n&quot;);
    			button_handler(local_event, display, infos);
    		break;
    		case KeyPress:
    			printf(&quot;Keyboard key pressed\n&quot;);
    			keyboard_handler(local_event, display);
    		break;
    		case ClientMessage:
    			printf(&quot;------------ClientMessage\n&quot;);
    			printf(&quot;\tMessage: %s\n&quot;, XGetAtomName(display,local_event.xclient.message_type));
    			printf(&quot;\tFormat: %d\n&quot;, local_event.xclient.format); 
    			Atom *atoms = (Atom *)local_event.xclient.data.l;
    			int i =0;
    			for(i=0; i&lt;=5; i++){
    				printf(&quot;\t\tData %d: %s\n&quot;, i, XGetAtomName(display, atoms[i]));
    			}
    			int nchild;
    			Window *child_windows;
    			Window parent_window;
    			Window root_window;
    			XQueryTree(display, local_event.xclient.window, &amp;root_window, &amp;parent_window, &amp;child_windows, &amp;nchild);
    			printf(&quot;\tNumber of childs: %d\n&quot;, nchild);
    		break;
    	}

Now in the clientmessage actually I&#39;m just trying to see collect some information to understand what is happening. And what I can see from the code above, is that the window that raised the event contains one child (again: is that the menu? or not?)

The code for the MapNotify event, where I add the decoration is the following: 

    void map_notify_handler(XEvent local_event, Display* display, ScreenInfos infos){
    	printf(&quot;----------Map Notify\n&quot;);
    	XWindowAttributes win_attr;
    	char *child_name;
    	XGetWindowAttributes(display, local_event.xmap.window, &amp;win_attr);
    	XFetchName(display, local_event.xmap.window, &amp;child_name);
    	printf(&quot;\tAttributes: W: %d - H: %d - Name: %s - ID %lu\n&quot;, win_attr.width, win_attr.height, child_name, local_event.xmap.window);
    	Window trans = None;	
    	XGetTransientForHint(display, local_event.xmap.window, &amp;trans);	
    	printf(&quot;\tIs transient: %ld\n&quot;, trans);
    	if(child_name!=NULL){
    	  if(strcmp(child_name, &quot;Parent&quot;) &amp;&amp; local_event.xmap.override_redirect == False){
    		Window new_win = draw_window_with_name(display, RootWindow(display, infos.screen_num), &quot;Parent&quot;, infos.screen_num, 
    						   win_attr.x, win_attr.y, win_attr.width, win_attr.height+DECORATION_HEIGHT, 0, 
    						   BlackPixel(display, infos.screen_num));
    		XMapWindow(display, new_win);
    		XReparentWindow(display,local_event.xmap.window, new_win,0, DECORATION_HEIGHT);
    		set_window_item(local_event.xmap.window, new_win);
    		XSelectInput(display, local_event.xmap.window, StructureNotifyMask);
    		printf(&quot;\tParent window id: %lu\n&quot;, new_win);
    		put_text(display, new_win, child_name, &quot;9x15&quot;, 10, 10, BlackPixel(display,infos.screen_num), WhitePixel(display, infos.screen_num));
    	  }
    	}
    	XFree(child_name);
    }

Now can someone help me with these problems? Unfortunately I already googled many times, but without success. 

To sum up, my issues are two: 
1. How to show subwindows from Firefox
2. How to show the File, Edit menu. 

**UPDATE**

I noticed something strange testing Firefox with xev to understand what events are fired in order to show an application. I saw that using Firefox in unity, and using Firefox in another window manger, the events fired are completely different. In Unity I have only: 

1. ClientMessage
2. UnmapNotify

Instead using Firefox, for example with xfce4, the xevents generated are more:

1. VisiblityNotify (more than one)
2. Expose event (more than one)

But if I try to enable VisibilityChangeMask in my wm, I receive the following events:

 - ConfigureNotify
 - ClientMessage
 - MapNotify
 - 2 UnMapNotify

**UPDATE 2**

I tried to read the XWMhints properties in the ClientMessage window (probably the men&#249; window) and the values are: 

 - For the flags 67 = InputHint, StateHint, WIndowGroupHint

 - For the initial state NormalState

**UPDATE 3**

I tried to look how another window manager works, and I was looking at the source code of calmwm. What is my understanding is that, when the ClientMessage event arrives, with a _NET_WM_STATE message, it updates these properties, and in the case of _NET_WM_STATE_HIDDEN it clears this property, and the result will be that the property will be deleted. So I tried to update my code to delete that property, but it&#39;s still not working. Anyway the relevant updated code in client_message_handler now looks like this:

    Atom *atoms = (Atom *)local_event.xclient.data.l;
    int i =0;
    for(i=0; i&lt;=5; i++){
    	printf(&quot;\t\tData %d: %s\n&quot;, i, XGetAtomName(display, atoms[i]));
    	if(i==1){
    		printf(&quot;\t Deleting Property: _NET_WM_STATE_HIDDEN \n&quot;);
    		XDeleteProperty(display, cur_window, atoms[i]);
    	}
    }

It is only a test, and I&#39;m sure that i=1 in my case is the _NET_WM_STATE_HIDDEN property. 

Here a link to calmwm source code: https://github.com/chneukirchen/cwm/blob/linux/xevents.c

So I&#39;m still stuck at that point. 

**UPDATE 4**

Really I don&#39;t know if it helps, but I tried to read the window attributes in the MapNotify Event, and the window map_state is IsViewable (2).

**UPDATE 5**

I found a similar problem here in SO, using xlib with python: https://stackoverflow.com/questions/32390790/xlib-python-cannot-map-firefox-menus

The solution suggests to use XSetInputFocus, i tried that on my XMapNotify handler: 

    XSetInputFocus(display, local_event.xmap.window, RevertToParent, CurrentTime);

But it still doesn&#39;t help, the firefox menu still doesn&#39;t appear!!
And i have the same problem with right-click.

**UPDATE 6**

Playing with xconfigurenotify event and unmap event i found that the:
Xconfigure request has 2 window fields: window and above, and when the 
the xconfigurerequest.window value is the same of xunmap.window value.

And also that the xconfigurerequest.above is always changing, but xconfigurerequest.window is always the same in all events.

It seems that the xconfigurerequest.above is related to what menu i&#39;m trying to open. For example: 

 - if right-click on a page i get an id (always the same for every subsequent click)
 - if i right-clik on a tab, the above value is another one
 - and the same happen if i left-click the firefox main menu

Still don&#39;t know if that helps.

Really don&#39;t know 
Anyone got any idea? 

Xlib and Firefox behavior

I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which is of size 500+ MB.

I read about running scripts [here][1], but I didn&#39;t understand the way. Is there any command or query by which we can run this sql script by providing path?


  [1]: https://stackoverflow.com/questions/13137258/oracle-sql-developer-how-to-dynamicly-run-sql-scripts

How to run .sql file in Oracle SQL developer tool to import database?

<p>I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which is of size 500+ MB.</p>
<p>I read about running scripts <a href="https://stackoverflow.com/questions/13137258/oracle-sql-developer-how-to-dynamicly-run-sql-scripts" target="_blank" rel="noopener noreferrer">here</a>, but I didn't understand the way. Is there any command or query by which we can run this sql script by providing path?</p>


I need to fetch details from DB. Any thing wrong in my code?

    SELECT DISTINCT FNAME, LNAME, MEMBERORG, DAYCOUNT, TIMESTAMP, COUNT(FNAME) AS total,(SELECT COUNT(*) FROM REPORT_VIEW_PAGE) AS tot
    FROM REPORT_VIEW_PAGE 
    WHERE ID = &#39;68&#39; AND TYPE = &#39;node&#39;
    GROUP BY FNAME, LNAME, MEMBERORG, DAYCOUNT, TIMESTAMP
    ORDER BY TITLE ASC

This giving me an error:

    ORA-01791: not a SELECTed expression
    01791. 00000 -  &quot;not a SELECTed expression&quot;
    *Cause:    
    *Action:
    Error at Line: 6 Column: 10

ORA-01791: not a SELECTed expression

I need to store both **time** and **date** in the mysql. So I used of `NOW()` function for that. But I don&#39;t know what should I use for *type column* im phpmyadmin. It should be noted that `NOW()` returns both time and date like this:
 

    2014-11-11 12:45:34

Here is a solution, I can use of a separator for separating date and time (`2014-11-11` and `12:45:34`) and then store them in the DATE type and TIME type individually. Or I can use of VARCHAR type for storing both of them in one column. But I think these ways are not standard. what is standard type for storing both date and time ?

Here is my query: (also I don&#39;t know why `NOW()` function does not works)

    INSERT INTO table (timedate) VALUES (NOW())

What difference between the DATE, TIME, DATETIME, and TIMESTAMP Types

Refering to this:
https://stackoverflow.com/questions/164319/is-there-any-difference-between-group-by-and-distinct

    Given a table that looks like this:
    
    name
    ------
    barry
    dave
    bill
    dave
    dave
    barry
    john
    This query:
    
    SELECT name, count(*) AS count FROM table GROUP BY name;
    Will produce output like this:
    
    name    count
    -------------
    barry   2
    dave    3
    bill    1
    john    1


What is the correct Rails convention here for ActiveModel to perform a GROUP BY with COUNT?



GROUP BY and COUNT using ActiveRecord

Consider a SQL query with the following `WHERE` predicate:

    ...
    WHERE name IS NOT NULL
    ...

Where `name` is a textual field in PostgreSQL.

No other query checks any textual property of this value, just whether it is `NULL` or not. Therefore, [a full btree index][1] seems like an overkill, even though [it supports this distinction][1]:

&gt; Also, an IS NULL or IS NOT NULL condition on an index column can be used with a B-tree index.

**What&#39;s the right PostgreSQL index to quickly distinguish `NULL`s from non-`NULL`s?**


  [1]: http://www.postgresql.org/docs/9.3/static/indexes-types.html

PostgreSQL: Create an index to quickly distinguish NULL from non-NULL values

I want to select information from two SQL tables within one query, the information is unrelated though, so no potential joints exist.

An example could be the following setup.

tblMadrid

       id | name    | games | goals
        1 | ronaldo | 100   | 100
        2 | benzema | 50    | 25
        3 | bale    | 75    | 50
        4 | kroos   | 80    | 10

tblBarcelona

       id | name    | games | goals
        1 | neymar  | 60    | 25
        2 | messi   | 150   | 200
        3 | suarez  | 80    | 80
        4 | iniesta | 40    | 5

I want to have a query that gives me the following:

    name    | games | goals
    messi   | 150   | 200
    ronaldo | 100   | 100

I tried to follow this logic: https://stackoverflow.com/questions/1775168/multiple-select-statements-in-single-query but the following code did not work:

	USE Liga_BBVA

	SELECT (SELECT name,
				   games,
				   goals
			FROM   tblMadrid
			WHERE  name = &#39;ronaldo&#39;) AS table_a,
		   (SELECT name,
				   games,
				   goals
			FROM   tblBarcelona
			WHERE  name = &#39;messi&#39;)   AS table_b
	ORDER  BY goals 


Any advice on this one? Thanks
Info: The football stuff is just a simplifying example. In reality it is not possible to put both tables into one and have a new &quot;team&quot; column. The two tables have completely different structures, but I need something that matches the characteristics of this example.

SQL: Two select statements in one query

I just installed _Oracle_, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query: 
```
create user Scott identified by tiger; 
```
it displays the following error: 

&gt;ORA-65096: invalid common user or role name in oracle. 

Basically it is not allowing me to create a user Scott. 

Why is that, and how can I fix my problem?

error: ORA-65096: invalid common user or role name in oracle

How can I insert into table with different input using /   ,with **date datatype**?

    insert into run(id,name,dob)values(&amp;id,&#39;&amp;name&#39;,[what should I write here?]);

I&#39;m using  oracle 10g.
 


How to insert date values into table

I&#39;m watching a Script in Oracle and I see something I don&#39;t recognize
    
    REM INSERTING into database1.&quot;Users&quot;
     SET DEFINE OFF;
    Insert into database1.&quot;Users&quot; (&quot;id&quot;,&quot;right&quot;) values (&#39;1&#39;,&#39;R&#39;);

I&#39;m looking for documentation about &quot;set define off&quot; and it&#39;s literally writing &quot;disable the parsing of commands to replace substitution variable with their values&quot;

I don&#39;t really understand what they want to say.

Can anyone help me?

When or Why to use a &quot;SET DEFINE OFF&quot; in Oracle Database

I created the table Test_Project2 in Oracle SQL Developer. After that I realized that the column proj_name is of a small size, so I decided to modify the column using the follwoing statement

	ALTER TABLE TEST_PROJECT2 MODIFY proj_name VARCHAR2(300);
	
but for some reason Oracle SQL Developer underscores the semi-colon with red and I do not what is mistake and how to correct it

**Test_Project2**:

	CREATE TABLE Test_Project2 (
	proj_id number(30),
	proj_name VARCHAR2 (30),
	proj_desc VARCHAR2(300)
	);

how to modify the size of a column

I downloaded Windows 64-bit with JDK 8 included of SQL Developer 18.1.

To run Oracle SQL Developed I just unzipped the file and run the sqldeveloper.exe contained in the folder.

Unfortunately, as you can see in the image the size of everything is extremely small and very difficult to see.[![enter image description here][1]][1]

This issue appears exclusively with this software.

How can I resolve it? 

  [1]: https://i.stack.imgur.com/g3Znw.png

Content Type	Original Author	Original Content on Stackoverflow
Question	Madhusudan	View Question on Stackoverflow
Solution 1 - Sql	Lalit Kumar B	View Answer on Stackoverflow
Solution 2 - Sql	Sandeep	View Answer on Stackoverflow
Solution 3 - Sql	Woodchuck	View Answer on Stackoverflow
Solution 4 - Sql	Bipil Raut	View Answer on Stackoverflow

How to run .sql file in Oracle SQL developer tool to import database?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Xlib and Firefox behavior

How to store a file with file extension with multer?

Attributions